Build MySQL to connect to the root user remotely

Everyone in the remote connection to MySQL should have encountered, the root user of MySQL, can only be locally connected, foreign refused to connect.

We need to create a database account that allows remote logins so that you can easily operate the database locally.

Here's how:

1. Confirm Login Privileges

By default, the user rights within the MySQL database Mysql,user table in Linux are only allowed to land on localhost.

Need to change permissions:

The following method confirms:

Root#mysql-h Localhost-u Mysql-p

Enter Password: ******

Welcome to the MySQL Monitor. Commands End With; or \g.

Your MySQL Connection ID is 4 to server Version:4.0.20a-debug

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the buffer.

mysql> use MySQL; (This DB holds various configuration information for MySQL)

Database changed

Mysql> select Host,user from user; (View the user's permission condition)

Mysql> Select Host, user, password from user;

+-----------+------+-------------------------------------------+

| Host | user | password |

+-----------+------+-------------------------------------------+

| localhost | Root | *4acfe3202a5ff5cf467898fc58aab1d615029441 |

| 127.0.0.1 | Root | *4acfe3202a5ff5cf467898fc58aab1d615029441 |

|      localhost |                                           | |

+-----------+------+-------------------------------------------+

4 rows in Set (0.01 sec)

As you can see, you can only access it as a host of localhost.

2. Workaround:

Mysql> Grant all privileges on * * to ' root ' @ '% ' of ' identified by ' MySQL ' with Grant option;

(% means all external machines, if a certain machine is specified, the% is changed to the corresponding machine name; ' root ' means the username to be used.)

mysql> flush Privileges; (Run as a sentence to take effect, or restart MySQL)

Query OK, 0 rows affected (0.03 sec)

Check again:

Mysql> Select Host, user, password from user;

+-----------+------+-------------------------------------------+

| Host | user | password |

+-----------+------+-------------------------------------------+

| localhost | Root | *4acfe3202a5ff5cf467898fc58aab1d615029441 |

| 127.0.0.1 | Root | *4acfe3202a5ff5cf467898fc58aab1d615029441 |

|      localhost |                                           | |

| %         | Root | *4acfe3202a5ff5cf467898fc58aab1d615029441 |

+-----------+------+-------------------------------------------+

4 rows in Set (0.01 sec)

It can be seen that a new user has been added

Quit, try the effect ....

Login successfully:

This article is from the "Longan" blog, please be sure to keep this source http://xulongping.blog.51cto.com/5676840/1598003

Build MySQL to connect to the root user remotely