Solve Problems Related to remote MYSQL access by root users

Solve the problem that the root user can remotely access MYSQL: SQLError (1130): Host10.16.1.50isnotallowedtoconnecttothisMySQLserver indicates that the connected user account does not have the permission to remotely connect, and can only log on to the Local Machine (localhost. You need to change the host entry in the user table in the mysql database to change localhost to %

Solve the problem that the root user remotely accesses MYSQL: SQL Error (1130): Host '10. 16.1.50 'is not allowed to connect to this MySQL server indicates that the connected user account has no remote connection permission and can only log on to the Local Machine (localhost. You need to change the host entry in the user table in the mysql database to change localhost to %

Solve the Problem of remote MYSQL access by root users

SQL Error (1130): Host '10. 16.1.50 'is not allowed to connect to this MySQL server

This indicates that the connected user account does not have the permission for remote connection and can only log on to the Local Machine (localhost.

You need to change the host entry in the user table of the mysql database.

Rename localhost as %

First, log on to the Mysql server by following the steps below

To log on to mysql, you need to switch to the bin directory of mysql under dos and perform the following operations:

Mysql> use mysql;

?

?

Mysql> update user set host = '% '? Where user = 'root ';

?

?

Mysql> flush privileges;

?

?

Mysql> select 'host', 'user' from user where user = 'root ';

?

?

Mysql> quit

?

?

Source: http://blog.csdn.net/xianyao_shi/article/details/7190877

?

Http://blog.csdn.net/tys1986blueboy/article/details/7056835