After installing MySQL, turn on remote login

On the internal test server to install the new MySQL, the server log on to the database is not a problem, but remote can not log in, try to use the Telnet command to connect to the MySQL server, the result command line gives the following prompt:

Telnet 192.168.41.191 3306
Trying 192.168.41.191 ...
Connected to 192.168.41.191.
Escape character is ' ^] '.
GHost ' 192.168.41.186 ' isn't allowed to connect to this MySQL serverconnection closed by foreign host.

Initially suspected that the firewall port is not open, directly shut down the firewall, or not.

Then wonder what rules the router has set for server access. Knowing that the router did not add any filtering rules, the problem should not be the router.

Later found that MySQL default is not open Telnet, good embarrassment, too ignorant.

Then we found a way to open the remote login. As follows:

1. Modify MySQL database table user's host field's localhost data to: "%"
   
2. Enter flush privileges on the console console of MySQL
   
3. Commit

After doing these three steps, log in to MySQL again using the remote machine, you can already connect.