linux--Building PHP Development Environment First step: MySQL

Original link: http://www.jb51.net/article/83647.htm

1. The first step is to see if Linu installed MySQL, after rpm-qa|grep mysql check see CentOS installed mysql5.1, then start unloading

2. The next step is to uninstall mysql5.1, command: Rpm-e mysql-libs--nodeps

3.yum after mysql5.1, installation or 5.1, now to add a new repo

RPM-UVH http://mirror.steadfast.net/epel/6/i386/epel-release-6-8.noarch.rpm

4. A total of two additional repo are required and now another

RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

5. Now check to see if some of the additions were successful, yum--enablerepo=remi,remi-test list MySQL Mysql-server

See below that the installation was successful.

6. The next step is to install mysql5.5.

Yum--enablerepo=remi,remi-test install MySQL Mysql-server

7. Be sure to select Y when this thing appears. Otherwise God can not save you, will have to reinstall.

8. See this image below to prove that your MySQL installation was successful.

9. Next you need to start MySQL

/etc/init.d/mysqld start

10. The following command is set to boot from the start, save us every time we boot up to start MySQL.

Chkconfig--levels 345 mysqld on

11. To enable MySQL security settings, enter the following command

/usr/bin/mysql_secure_installation

12. Check to see if MySQL was installed successfully. If the input sees the following interface, then you have installed successfully. Treat yourself to it.

MySQL off/On

Service Mysqld Stop/start

Remote Connection 1130 error, "Error 1130:host xxx.xxx.xxx.xxx is" not "allowed to connect to" this MySQL server

After you log in to MySQL, change the "host" entry in the "User" table in the "MySQL" Database, and rename it from "localhost" to "%".
Mysql-u root-p
Mysql;use MySQL;
Mysql;select ' host ' from user where user= ' root ';
Mysql;update User Set host = '% ' where user = ' root ';
Mysql;flush privileges;
Mysql;select ' host ' from user where user= ' root ';



First sentence: Log in as user root with permissions
Second sentence: select MySQL Library
The third sentence: View the host value of the user table in the MySQL library (hosts/IP names that can be accessed by the connection)
Clause Four: Modify the host value (increase the hostname/IP address with the wildcard%), or you can directly add
Clause five: Refresh MySQL system permissions related table
The sixth sentence: when you re-view the user table, there are modifications.
Restart the MySQL service to complete.

　　

linux--Building PHP Development Environment First step: MySQL