解决MySQL远程登陆失败问题

解决MySQL远程登陆问题：在登入mysql后，更改 “mysql” 数据库里的 “user” 表里的 “host” 项，从”localhost”改称'%'。

下面是用SQL语句解决问题：

1、以权限用户root登录
mysql -u root -p  

2、切换选择mysql库
use mysql;  
3、查看mysql库中的user表的host值
select 'host' from user where user='root';  

4、修改host值（以通配符%的内容增加主机/IP地址），当然也可以直接增加IP地址
update user set host = '%' where user ='root';  

5、刷新MySQL的系统权限相关表
flush privileges; 

执行案例：

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| zhuemall_bi        |
+--------------------+
5 rows in set (0.00 sec)

mysql> use mysql;
Database changed
mysql> select 'host' from user where user='root';
+------+
| host |
+------+
| host |
+------+
1 row in set (0.00 sec)

mysql> update user set host = '%' where user ='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)