You need two servers first (you can also use one, but not recommended)
1 server with Yum installation Apache+php+php-mysql
2 server install MySQL with yum
1 server with Yum installation Apache and Php+php-mysqlyum install Httpd-yyum install php-yYum installs Php-mysql Firewall and Setenforce must be turned off (permanently closed) after completion
Install the HTTPD service after the page needs to put the files into the/var/www/html/folder
2 server yum Install mysql-server-y//Install database service MySQL restart //restart database MySQL /Access database management
show databases; #查看表
Create user ' aa01 ' @ ' 192.168.100.150 ' identified by ' 123456 '; Create a user for 192.168.100.140, that is, the user created can only log on 192.168.100.140
Create Database Xyq; #创建xyq数据库
Grant all privileges the xyq.* to ' aa01 ' @ ' 192.168.100.150 '; Give a user the right to specify a database, * represent all tables
Enter XYQ database: Use XYQ;
Creating SQL Data tables
Write the SQL statement to the data table (paste the existing data table in)
View Data Sheet
Show tables;
Shutting down firewalls and stenforece 0
Folder configuration to enter 1 server:/var/www/html/
Open connect.php
Exit after completion
Restarting the HTTPD server (preferably restarting the MySQL service)
The construction of the wishing Wall is based on MySQL