Construction of the Wishing Wall website based on Apache+php+mysql

Two servers required first

A server-installed Apache+php+php-mysql website

b Server Install MySQL

a server uses Yum to install Apache and PHP+php----

b server yum install MySQL // Install database service MySQL restart/   / Restart database mysql  /Access database management

View table: show databases;

Create user ' aa01 ' @ ' 192.168.100.140 ' 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; Create a XYQ database

Grant all privileges the xyq.* to ' aa01 ' @ ' 192.168.100.140 '; Give a user the right to specify a database, * represent all tables

Enter XYQ database: Use XYQ;

Creating SQL Data tables

View Data Sheet again

Show tables;

Shutting down firewalls and stenforece 0

Enter the folder configuration for Server A:/var/www/html/

Open connect.php

Save exit

Restarting the HTTPD server

Construction of the Wishing Wall website based on Apache+php+mysql