Host XXX is not allowed to connect to this MySQL server

use mysql;
 
select host from user where user='root';
update user set host = '%' where user ='root';
flush privileges;

还有一点就是阿里云那边一定是要开放的,防火墙什么的都需要注意下

posted @ 2021-06-23 11:23  正义的棒棒糖  阅读(75)  评论(0编辑  收藏  举报