navicat 连接 mysql失败报错 is not allowed to connect to this MySQL server 解决方法_navicat 连接mysql not allowed to connect to this mys

作者：从前慢现在也慢 | 2024-07-06 09:41:13

踩

navicat 连接mysql not allowed to connect to this mysql server

最近开始学mysql
navicat是个很好的gui工具
刚开始学就踩坑，连不上，报错is not allowed to connect to this MySQL server
查了一会，发现是主机地址问题

此文章为意思补全文章，帮助新手小白理解命令作用
感谢单手入天象大佬的文章

mysql -u root -p
1

use mysql;
1

select host from user where user='root';
1

update user set host = '%' where user ='root';
1

flush privileges;
1

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/从前慢现在也慢/article/detail/792483

navicat 连接 mysql失败 报错 is not allowed to connect to this MySQL server 解决方法_navicat 连接mysql not allowed to connect to this mys