Mysql报错is not allowed to connect解决办法（开放权限）_is not allowed to connect mysql

作者：小桥流水78 | 2024-07-18 02:32:40

踩

is not allowed to connect mysql

欢迎关注原创视频教程

主机商放行3306端口

打开mysql控制台
mysql -u root -p
然后输入密码

use mysql;
show tables;


1
2
3
4

select host from user;
1

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

关闭权限

update user set host = "localhost" where user = "root" and host = "%";
1

flush privileges; 
exit
service mysqld restart
1
2
3

链接：

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