Construction of dynamic website wishing wall under lamp environment

Prepare for the environment before building, using the Linux distribution CentOS 7

1. Install and start Apache+mysql and place the file in the apache root directory/val/www/html

Installation and start-up method reference: http://www.cnblogs.com/dagege/p/5949620.html

2. First we first set up a user ' Dagege ' in the database, create a database ' Xyq ', give the user ' Dagege ' all permissions to the database ' XYQ '!

[Email protected] ~]# mysql-u root-p   #进入数据库Enter password:welcome to the MySQL monitor.  Commands End With; or \g.your MySQL connection ID is 4Server version:5.6.34 mysql Community Server (GPL) Copyright (c), Oracle and /or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help.　　　　Type ' \c ' to clear the current input statement.mysql> create user ' dagege ' @ ' 127.0.0.1 ' identified by ' Dagege ';　　　　#创建用户和密码, and bind Ipquery OK, 0 rows Affected (0.00 sec) mysql> CREATE database Xyq;　　　　#创建数据库Query OK, 1 row Affected (0.00 sec) Mysql> Grant all privileges in xyq.* to ' dagege ' @ ' 127.0.0.1 '; #给来自IP: 127.0.0.1 ' dagege ' user xyq all permissions to the database query OK, 0 rows Affected (0.00 sec)

3. Enter the database ' Xyq ' and import the SQL file (the link is extracted)

mysql> use XYQ; #进入数据库Database changed
mysql> [Copy all the contents of two SQL files paste it over] #导入sql文件

4. Install Php-mysql (configure local Yum source)

[[email protected] xyq]# yum install php-mysql loaded plugin: fastestmirror, langpacksloading mirror speeds from cached Hostfile * C6-media: Resolving dependencies There is unfinished transactions remaining. You might consider running yum-complete-transaction, or "Yum-complete-transaction--cleanup-only" and "Yum redo LA St ", first to finish them. If those don ' t work for you ' ll has to try removing/installing packages by hand (maybe Package-cleanup can help) .--> is checking transactions ---> Package php-mysql.x86_64.0.5.4.16-36.el7_1 will be installed--processing dependencies php-pdo (x86-64) = 5.4.16-36.el7_1, which is the package php-mysql-5.4.16-36.el7_1.x86_64 required--Checking transaction---> Package php-pdo.x86_64.0.5.4.16-36.el7_1 will be installed-- Resolve dependencies to complete dependency resolution =================================================================================================                             ========================================================== Package Architecture Version Source Size ========================================================================================================================== ================================= Installing: Php-mysql x86_64 5.4.16-36.el7_                           1 C6-media K for dependency installation: Php-pdo x86_64 5.4.16-36.el7_1 C6-media-K transaction summary ========= ===============================================================================================================  =================================== Install 1 packages (+1 dependent packages) Total Downloads: 196 k installation Size: 424 kIs This OK [y/d/n]: ydownloading packages:error  Downloading packages:php-pdo-5.4.16-36.el7_1.x86_64: [Errno] No more mirrors to try. PHP-MYSQL-5.4.16-36.EL7_1.X86_64: [Errno] No more mirrors to try.

5. Modify the file connect.php then save!

<?php$host= "127.0.0.1";　　　　Here writes the MySQL host's ip$db_user= "Dagege";　　　　Here write the username we just created $db_pass= "Dagege";　　　　　Here write the password $db_name= "Xyq"; Here write the database we created $timezone = "Asia/shanghai"; $link =mysql_connect ($host, $db _user, $db _pass); mysql_select_db ($db _name,$ link); mysql_query ("SET names UTF8"); header ("content-type:text/html; Charset=utf-8 ");d Ate_default_timezone_set ($timezone); Beijing time? >~        

6. Restart Apache service, turn off firewall and SELinux

[Email protected] xyq]# systemctl restart Httpd.service

[Email protected] xyq]# Systemctl stop Firewalld.service

[Email protected] xyq]# Setenforce 0

Construction of dynamic website wishing wall under lamp environment