Java.sql.SQLException:null, message from server: "Host ' xxx ' isn't allowed to connect

Java.sql.SQLException:null, message from server: "Host ' xxx ' isn't allowed to connectJune 29, 2014 ⁄ general ⁄ a total of 637 characters ⁄ font size small medium big ⁄ comments off

Java.sql.SQLException:null, message from server: "Host ' xxx ' isn't allowed to connect to this MySQL server":

Java.sql.SQLException:Access denied for user ' root ' @ ' xxx.xxx.xxx.xxx ' at (database name)

Indicates that the object is not a remote object and that the data cannot be accessed remotely through the object

Solve:

Plan One: Change the table:

Use MySQL, select User,host,password from user;

Update user Set host = '% ' where user= ' root ';

Programme II: 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 ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;

Regardless of which scenario you use, restart the MySQL service.

Http://hi.baidu.com/soutnila/item/5356f2c0002781bf0d0a7bae

Java.sql.SQLException:null, message from server: "Host ' xxx ' isn't allowed to connect