Host is not allowed to connect to this MySQL server---------------->WINDOWS10

Error, the database cannot be connected remotely.

The first step is to turn off the local firewall

Attention:

Both connected machines need to be shut down.

In the second step, two machines ping each other to see if they can access each other.

Lost to zero, meaning can be connected.

Step three log in to the database

The fourth step, switch, the database for MySQL, authorized access, because is local connection, so, gave all permissions

Fifth step: Modification takes effect

Flush privileges;

The other way is not full permission to give

Allow a specific user to access the machine, for example: 192.168.31.255

1 Grant all privileges the dk.* to ' myuser ' @ ' 192.168.31.255 ' identified by ' mypassword ' with GRANT option; 2 flush privileges;

View Code

Host is not allowed to connect to this MySQL server---------------->WINDOWS10