Troubleshooting MySQL Remote access

If you are connecting to MySQL with a similar error of ' Host ' win-s ' ip0ab0uc68 is not allowed to connect to this MySQL server, try using the following solution:

Programme one:

进入mysql，执行以下语句(‘root‘是用户名,‘123456‘是密码)use mysql;grant all privileges on *.* to [email protected]"%" identified by ‘123456‘ with grant option;

Scenario Two:

use mysql;update user set host=‘%‘ [where user=‘root‘];flush privileges;

If the above statement does not solve the problem, try the following sentence:

grant all on *.* to p" Identified by "123456";

The meaning of this sentence is that the authorized client IP, can use the user name root, password 126456 access to the server

Troubleshooting MySQL Remote access