Remote connection MySQL is not allowed to connect to this MySQL server

There are two ways of handling

1, (How to resolve the client-server connection (MySQL): xxx.xxx.xxx.xxx is not the allowed to connect the this MySQL serv
ER) Authorization law. For example, if you want to myuser use MyPassword to connect to a MySQL server from any host.

GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;

If you want to allow users to connect to the MySQL server from a host myuser IP 192.168.1.3 and use MyPassword as the password

GRANT all privileges on * * to ' root ' @ ' 192.168.1.3′identified by ' mypassword ' with GRANT OPTION; Grant all privileges on * * to ' root ' @ ' 10.10.40.54′identified by ' 123456′with GRANT OPTION;

2, change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from "localhost" to "%"

This is because of the permissions of the problem, the way to handle the following:

Shell>mysql--user=root-pmysql>use mysqlmysql>grant select,insert,update,delete on [db_name].* to [username] @[ipadd] identified by ' [Password] ';

Enter password

[Username]: User code for remote login
[Db_name]: Indicates the database to be open to users
[Password]: User password for remote login
[IPADD]:IP address or IP reverse DNS Name, the contents of this example must be filled in ' 60-248-32-13.hinet-ip.hinet.net ', the package is enclosed in quotation marks (')

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Remote connection MySQL is not allowed to connect to this MySQL server