Troubleshoot problems that do not have access to remote MySQL

Generally does not give the user access rights

Give the user Test_user authorization so that he can log in from outside and log in locally
Note: The left side is the username, the right side is the domain name, the IP and%, the domain name that can access MySQL and ip,% means that any external address can be accessed.

Mysql> Grant all privileges on * * to ' test_user ' @ ' localhost ' identified by ' test_user ';  Query OK, 0 rows Affected (0.00 sec)  mysql> grant all privileges on * * to ' test_user ' @ '% ' identified by ' Test_user ';  Query OK, 0 rows Affected (0.00 sec)  mysql> select User,host,password from Mysql.user;  

Troubleshoot problems that do not have access to remote MySQL