MySQL remote connection denied connection error

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 ';

The first sentence is to log in as the 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.

Remember that the MySQL service needs to be restarted (make sure the changes are valid), otherwise the result of the modification may not be reflected.

****************************************************************************

The above is the solution provided on the Internet, but I carry out to the four innings, it will be due to the main key issues and do not go on.

In the end, I found that it was also possible to solve this problem:

After logging in: mysql>grant all privileges on * * to ' username ' @ '% ' identified by ' password ' with GRANT OPTION;

This means that any remote host is allowed to log in to the database with the username name and password password

Finally:mysql> FLUSH privileges; ok.

MySQL remote connection denied connection error