1130-host ... is not allowed to connect to this MySql server

死神萝莉

于 2024-07-25 15:49:47 发布

阅读量148

点赞数 3

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/u010741500/article/details/140691767

版权

mysql 专栏收录该内容

2 篇文章

订阅专栏

mysql不能远程连接时：

1.登录mysql

mysql -u root -p密码

2.查看user表

select host,user from mysql.user;

+-----------+---------------+
| host      | user          |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys     |
| localhost | root          |
+-----------+---------------+

3.将user的host改成%

UPDATE mysql.user  SET host = '%'  WHERE user = 'root';

4.刷新数据库

FLUSH PRIVILEGES;

5.查看user表

select host,user from mysql.user;

+-----------+---------------+
| host      | user          |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys     |
| %         | root          |
+-----------+---------------+