Mysql can only be connected by localhost.

Mysql can only connect to localhost, so other machines are not allowed to access ERROR 1130: Host ***. ***. ***. * ** is not allowed to connect to this MySQL server to log on to mysql first, use mysql; an error occurs when updating according to the method provided by others. Mysql> update user set host = '%' where user = 'root'; ERROR 1062 (23000 ): duplicate entry '%-root' for key 'Primary' and then view the host information of the database as follows: mysql> select host from user where user = 'root '; + ------------- + ------ + | host | user | + ------------- + ------ + | % | root | 127.0.0.1 | root | MicroLetter | root | localhost | + ------------- + ------ + host already has the value %, so run the command: mysql> flush privileges;