Workaround: 1. Change the table method. may be your account is not allowed to login from remote, only on localhost. This time, as long as the computer in localhost, log in to MySQL, change the "MySQL" database "user" table "host", from "localhost" renamed "%" mysql -u Root-pvmwaremysql>use MySQL; www.2cto.com mysql>update User Set host = '% ' where user = ' root '; mysql>select host, User from User; 2. 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 ' @ '% ' identified by ' MyPassword ' with GRANT option; flush &NB Sp privileges; if you want to allow the user myuser to connect to the MySQL server from the IP 192.168.1.6 host and use MyPassword as the password grant all Privileges on * * to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION; www.2cto.com flush privileges; If you want to allow users to connect to the MySQL server's DK database myuser from the IP 192.168.1.6 host, and use MyPassword as the password grant all privileges on dk.* to ' MyUser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT option;   FLUSH privileges; I used the first method, just started to find no, in the online check, less execute a statement mysql>flush rivileges make the changes take effect. It's okay Another way, but I didn't try it myself, looking for it on the csdn.net, you can see . running on the MySQL-installed machine: www.2cto.com 1, D:\mysql \bin\>mysql h localhost -u root//This should allow access to MySQL server 2, mysql>grant All Privileges on * * to ' root ' @ '% ' with GRANT OPTION//give any host access to data 3, Mysql>flush privileges//Modify effective 4, Mysql>exit//exit MySQL server This will allow you to log in as root on any other host!
Message from server: "Host ' xxx ' isn't allowed to connect to this MySQL server resolution
