"MySQL" Configuring MySQL installation and remote access steps

Take the remote server as an example, install MySQL to Linux and configure remote access, as follows: 1. Download and install the latest RPM file method one:

RPM-UVH http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

Method Two:

(The latest version of address: http://mirrors.sohu.com/mysql/) 2. Install MySQL and enter the command:

Yum Install Mysql-community-server

3. Check the version number after installation

Mysql-v

4. Start MySQL and enter the command:

Service mysqld Start

5. Configure MySQL boot to start automatically

Chkconfig mysqld on

6. View configuration Status

Chkconfig--list | grep MySQL

7. Set the password for the administrator

Mysqladmin-u Root Password

--------Configure remote access---------8. Enter the database

Mysql-u root-p

9. See how many databases you have

show databases;

10. Go to MySQL Database

Use MySQL;

11. Query The fields inside the user table

Select Host,user,password from user;

12. Then find the localhost root and a strip with password, and change the localhost to '% ' (note: This is the right to access the IP for the root account, it is better to create a new MySQL user to open, do not use root)

Update user set host= '% ' where password= ' *0049957dde5c3c58aed ';

13. Restart the MySQL service

Service mysqld Restart

14. Local Installation: Navicatpremium, open navicatpremium Create a new connection, a. Select general, enter database connection information B. Select SSH and enter the server's information to connect

"MySQL" Configuring MySQL installation and remote access steps