MySQL Remote connection Host * is not a allowed to connect to this MySQL server (first configuration good LNMP environment)

1. First time to build MySQL on Linux, native Windows remote link error host * is not allowed to connect to this MySQL server

2. Reason: MySQL server is only allowed to log on locally to the database server by default for security reasons.

Problem solving: After logging in to MySQL, change the "host" entry in the "User" table in the "MySQL" database, rename "%" from "localhost", and then restart MySQL so that all remote machines are allowed to access.

Step 1: Modify the MySQL table

Mysql-u Root-pvmware
Mysql>use MySQL;
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>flush privileges;
Mysql>select host, user from user;

Mysql>quit

Success!!!!

MySQL Remote connection Host * is not a allowed to connect to this MySQL server (first configuration good LNMP environment)