Cannot remotely access MySQL database solution

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 "%"

The code is as follows	Copy Code
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.

The code is as follows	Copy Code
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

The code is as follows	Copy Code
Grant all privileges in *.* 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

The code is as follows	Copy Code
Mysql>flush Rivileges to make the changes take effect. That's it.

　

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

Running on a MySQL-installed machine:

1, d:mysqlbin>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