解决MySQL远程登陆失败问题

```sql

解决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;

```
执行案例：
```sql
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)

mysql>
```