MySQL 1130错误,无法远程连接
原因:
可能是你的帐号不允许从远程登陆,只能在localhost
。登入mysql后,更改"mysql" 数据库里的 “user” 表里的 “host"项,从"localhost"改称”%"
步骤1
登陆mysql:
[root@localhost mysql]# bin/mysql -uroot -p
Enter password:
步骤2
mysql> use mysql;
查看用户表配置:
mysql> select user,host from user;
+---------------+-----------+
| user | host |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+---------------+-----------+
3 rows in set (0.00 sec)
从结果能看到默认的几个用户,他的允许访问的host均为localhost,远程被屏蔽了
修改host
mysql> update user set user.Host='%' where user.User='root';
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)
记得flush 一下,验证一下是否修改成功:
mysql> select user,host from user;
+---------------+-----------+
| user | host |
+---------------+-----------+
| root | % |
| mysql.session | localhost |
| mysql.sys | localhost |
+---------------+-----------+
再次远程连接即可