Deploy phpmyadmin in CentOS6; deploy Discuz; deploy phpwind_MySQL

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.