The construction of the wishing Wall is based on MySQL

Source: Internet
Author: User
Tags install php

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

Related Article

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.