mysql远程连接报错： Host * is not allowed to connect to this MySQL server，解决方法
localhost改成%
1.进入mysql的BIN目录
注：root为管理员用户名，password为用户root的密码：
mysql -u root -p password
mysql>use mysql;
mysql>update user set host ='%'where user ='root' and host ='localhost';
mysql>flush privileges;
注：这时候连接此服务器的mysql客户端需要重新启动下，然后再连接此服务器。
mysql> select host,user,password from user; +-----------------------+------+-------------------------------------------+ | host | user | password | +-----------------------+------+-------------------------------------------+ | localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | localhost.localdomain | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | 127.0.0.1 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | ::1 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | localhost | | | | localhost.localdomain | | | +-----------------------+------+-------------------------------------------+ 6 rows in set (0.00 sec) mysql> update user set host ='%'where user ='root' and host ='localhost.localdomain'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql>