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 install Apache and Php+php-mysqlyum installs Httpd-yyum install Php-yyum install php-mysql Firewall and Setenforce must be turned off (permanently closed) after completion
temporarily closed firewalld# systemctl Stop Firewalld.service
permanently close firewalld# systemctl Disable Firewalld.service
temporary shutdown selinux# Setenforce 0
Permanently close selinux#
Sed-i ' s/selinux=enforcing/selinux=disabled/'/etc/sysconfig/selinux
-I direct manipulation of files
The meaning of the s substitution
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 mysqld 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