MySQL does not allow 2 solutions from remote access

Workaround:

1. Change Table method

Your account may not be allowed to log in remotely, only in localhost. This time as long as the computer in localhost, login mysql, change the "MySQL" Database in the "User" table in the "host" item, from "localhost" renamed "%"

Mysql-u root-pvmwaremysql>use MySQL;

Mysql>update User Set host = '% ' where user = ' root ';

Mysql>select host, user from user;

2. Authorization Act

For example, you want to myuser use MyPassword to connect to a MySQL server from any host.

Grant all privileges in *.* to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;

FLUSH privileges;

If you want to allow the user to connect to the MySQL server from the IP-192.168.1.6 host, and use MyPassword as the password myuser

Grant all privileges in *.* to ' myuser ' @ ' 192.168.1.3′identified by ' mypassword ' with GRANT OPTION;

FLUSH privileges;

If you want to allow users to MyUser from IP-192.168.1.6 hosts to the MySQL server's DK database and use MyPassword as a password

Grant all privileges in 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, online check, less execution of a statement Mysql>flush Rivileges to make the changes effective. That's it.

Another method, but I did not personally tried, on the csdn.net look for, you can look.

Running on a MySQL-installed machine:

1, d:\mysql\bin\>mysql-h localhost-u root//This should be able to access the MySQL server

2. Mysql>grant all privileges in *.* to ' root ' @ '% ' with GRANT OPTION//give any host access to data

3. Mysql>flush Privileges//amendment effective

4. Mysql>exit//exit MySQL server

This allows you to log in as root on any other host!