Deploy phpmyadmin in CentOS6; deploy Discuz; deploy phpwind_MySQL

Deploy phpmyadmin in CentOS6; deploy Discuz; deploy phpwind CentOS6CentOSPHPwind

Part 1:

1. install LAMP platform in yum
2. deploy phpMyAdmin

Part 2:
I,Set up forum system Discuz

2. build the forum system PhpWind

3. build the forum system PhpBB

Part 3

I,Deploy the wordpress personal blog system

========================================================== ========================================================

1. phpMyAdmin overview

1. phpMyAdmin is a WEB-based tool developed based on PHP to manage Mysql databases. phpMyAdmin provides a user-friendly WEB interface, which is easy to use. It is the best tool for users who are not familiar with SQL statements.
PhpMyAdmin official website: http://www.phpmyadmin.net/home_page/downloads.php

2. install the LAMP platform

# yum -y install http php php-mysql php-mbstring mysql mysql-server

3. modify the Apache Main configuration file and add the default homepage as follows:

# vim /etc/httpd/conf/httpd.confDirectoryIndex index.php index.html index.html.varServerName localhost:80

4. start http and mysql services

# service httpd start# service mysqld start

5. create a new index. php file on the default webpage and write a test statement to check whether the database can be connected. the database user "root" has no password by default. we will set a password as follows;

# Mysqladmin-uroot-p password "phpmyadmin" # vim/var/www/html/index.phpwww.phpmyadmin.com
 
6. test access in the browser
7. modify the/etc/httpd/conf/httpd. conf file to create a virtual host for phpmyadmin. for example:
# Cd/etc/httpd/conf # cp httpd. conf httpd. conf. bak # vim httpd. conf add the following line NameVirtualHost 192.168.0.104: 80
  
   
ServerAdmin zhengyansheng@cdvcloud.comDocumentRoot/var/www/html/phpmyadminServerName www. phpmyadmin. comErrorLog logs/allentuns-error_logCustomLog logs/allentuns-access_log common
  
8. reload the configuration file
# service httpd reload
9. decompress the phpMyAdmin package
# cd /usr/local/src# tar xf phpMyAdmin-4.1.14-all-languages.tar.bz2 -C /var/www/html/# mv phpMyAdmin-4.1.14-all-languages phpmyadmin
10. because there is no DNS resolution, you need to add the following records to the local Hosts file:
C:/Windows/System32/Drivers/etc/hosts # open this file and add the following content: 192.168.0.20.www.phpmyadmin.com
11. open a browser on the client to check whether the logon is successful, as shown below:
12. login interface
Prompt that The phpMyAdmin advanced function is not set, and some are not activated. click [here] to view the reason.
13. first, modify the/var/www/html/phpmyadmin/config. inc. conf file as follows:
Remove the comments of the following lines/* Storage database and tables */$ cfg ['servers'] [$ I] ['pmadb'] = 'phpmyadmin '; $ cfg ['servers'] [$ I] ['bookmarktable'] = 'PMA _ bookmark '; $ cfg ['servers'] [$ I] ['relation'] = 'PMA _ relation '; $ cfg ['servers'] [$ I] ['Table _ info'] = 'PMA _ table_info '; $ cfg ['servers'] [$ I] ['Table _ coords '] = 'PMA _ table_coords '; $ cfg ['servers'] [$ I] ['PDF _ page'] = 'PMA _ pdf_pages '; $ cfg ['servers'] [$ I] ['column _ info'] = 'PMA _ column_info '; $ cfg ['servers'] [$ I] ['History '] = 'PMA _ history '; $ cfg ['servers'] [$ I] ['Table _ uiprefs '] = 'PMA _ table_uiprefs '; $ cfg ['servers'] [$ I] ['tracking'] = 'PMA _ tracking '; $ cfg ['servers'] [$ I] ['designer _ coords '] = 'PMA _ designer_coords '; $ cfg ['servers'] [$ I] ['userconfig'] = 'PMA _ userconfig '; $ cfg ['servers'] [$ I] ['recent '] = 'PMA _ recent '; $ cfg ['servers'] [$ I] ['users'] = 'PMA _ users '; $ cfg ['servers'] [$ I] ['usergroupup'] = 'PMA _ usergroupup '; $ cfg ['servers'] [$ I] ['navigationing ing '] = 'PMA _ navigationing ing ';
14. import The phpMyAdmin/examples/create_tables. SQL database file to the database as follows:
# mysql -uroot -pphpmyadmin < /var/www/html/phpmyadmin/examples/create_tables.sql
15. log on again and verify the password as follows:
========================================================== ========================================================
Part 2:
I. build a Discuz Forum
1. about Discuz
Discuz! X is a web service product that uses PHP as the programming language, MySQL as the database, and Apache/IIS/Nginx (any one. To build Discuz! Site X, the server must be installed in an environment consisting of PHP, MySQL, Apache/IIS/Nginx. IIS is mainly used for Windows servers, while Apache and Nginx are mostly used for Linux servers (LAMP and LNMP ).
2. deployment process
When deploying a Linux server, you must follow the deployment sequence, that is, system environment initialization-> Apache/Nginx, MySQL, PHP package download-> Apache/Nginx, MySQL, PHP installation
3. Software: http://download.comsenz.com/DiscuzX/3.1/Discuz_X3.1_ SC _UTF8.zip
4. upload or download the software package locally and decompress it to the Apache Site Directory.
[root@allentuns ~]# yum -y install unzip[root@allentuns ~]# cd /usr/local/src/[root@allentuns src]# lsDiscuz_X3.1_SC_UTF8.zip[root@allentuns src]# unzip Discuz_X3.1_SC_UTF8.zip[root@allentuns src]# lltotal 16480-rw-r--r--.1 root root 10443521 Apr 29 04:16 Discuz_X3.1_SC_UTF8.zipdrwxr-xr-x.2 root root 4096 Feb 28 14:52 readmedrwxr-xr-x. 12 root root 4096 Feb 28 14:52 uploaddrwxr-xr-x.4 root root 4096 Feb 28 14:52 utility[root@allentuns src]# cp -r upload /var/www/html/bbs[root@allentuns src]# chown -R apache /var/www/html/bbs/
5. add a VM as follows:
[root@allentuns ~]# vim /etc/httpd/conf/httpd.conf
  
   ServerAdmin zhengyansheng@cdvcloud.comDocumentRoot /var/www/html/bbsServerName www.bbs.comErrorLog logs/bbs-error_logCustomLog logs/bbs-access_log common
  
6. because no DNS server resolution is available, add the following records to the local Hosts file:
C:/Windows/System32/Drivers/etc/hosts # open this file and add the following content: 192.168.0.20.www.bbs.com
7. access the domain name www.bbs.com through the Google browser client. the domain name is installed as shown in figure
View the authorization agreement and click "I agree" to proceed to the next step;
Set the directory permissions under the site, and click [next] after all the permissions are passed, as shown in figure
Log on to the MySQL database, create a forum database, create a forum mysql User, and authorize
[Root @ allentuns ~] # Mysql-uroot-pEnter password: Welcome to the MySQL monitor. commands end with; or/g. your MySQL connection id is 96 Server version: 5.1.73 Source distributionCopyright (c) 2000,201 3, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. other names may be trademarks of their respectiveowners. type 'help; 'or'/h' for help. type '/C' to clear the current input statement. mysql> create database phpmyadmin # create a forum database mysql> insert into mysql. user (Host, User, Password) values ("localhost", "phpmyadmin", password ("phpmyadmin"); # Create a forum database administrator Query OK, 1 row affected, 3 warnings (0.00 sec) mysql> grant all privileges on phpmyadmin. * to phpmyadmin @ '%'; # grant phpmyadmin all permissions to the database Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; # Reload the authorization table Query OK, 0 rows affected (0.00 sec) mysql> select User, Host, Password from user; + ------------ + ----------- + hosts + | User | Host | Password | + ------------ + ----------- + hosts + | root | localhost | * hosts | root | allentuns | root | 127.0.0.1 | | localhost | allentuns | phpmyadmin | localhost | * success | # Added successfully | phpmyadmin | % | + ------------ + --------- + rows + 7 rows in set (0.00 sec)
Database name: phpmyadmin # New Database
Database username: phpmyadmin # New User
Database password: phpmyadmin
Data table prefix: default
Administrator account: admin
Administrator Password: admin
After entering the preceding information, click next]
: Click "continue access" next]
The Discuz Forum is successfully established, as shown in figure
After the bbs Forum is installed, it is best to delete or rename the install directory under the bbs Directory
[root@allentuns ~]# cd /var/www/html/bbs/[root@allentuns bbs]# mv install install.bak
Log on to the bbs forum again.
User logon interface
The bbs forum has been built !!!
========================================================== ==========================================
2. build the forum system PhpWind
1. phpwind introduction
PHPWind is a completely new and powerful system that runs in php + mysql database mode and can generate html pages.
2.