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 "%"
Copy Code code as follows:
Mysql-u root-pvmwaremysql>use MySQL;
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>select host, user from user;
2. The law of authorization. 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;
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 on *.* to ' myuser ' @ ' 192.168.1.3 ' identified by
' MyPassword ' with GRANT OPTION;
I used the first method, just started to find no, online check, less execution of a statement Mysql>flush Rivileges
Make the changes take effect, it's okay.
3. Another method:
Running on a MySQL-installed machine:
1, d:\mysql\bin\>mysql-h localhost-u root
This should allow access to the MySQL server
2, mysql>grant all privileges in *.* to ' root ' @ '% ' with GRANT OPTION
Give any host access to data
3, Mysql>flush privileges
Change takes effect
4, Mysql>exit
Exit MySQL Server
This allows you to log in as root on any other host.
If the above operation does not solve the problem, it may be the security of the server problem, whether the IP security policy or firewall does not open the 3306 exception.
