SQLyog连接linux数据库问题

雾山雨巫

于 2022-10-17 20:34:09 发布

阅读量539

点赞数

文章标签： linux 运维服务器数据库

本文链接：https://blog.csdn.net/qq_21921805/article/details/127374869

版权

使用SQLyog连接数据库时报错：

error number: 2003, Can't no connet to MySQL server on 192.168.186.X

systemctl stop firewalld    //关闭防火墙
systemctl disable firewalld

error number：1130，Host is not allowed to connect to this MySQL server

解决办法:

update user set host='%' where user='root'  //需要配置允许远程连接

flush privileges;

2509 plugin caching_sha2_password could not be loaded

解决办法：

ALTER USER 'root'@'localhost' IDENTIFIED BY 'ABCabc123!' PASSWORD EXPIRE NEVER;  //更改加密方式

//如果报错ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost' 
//因为你设置了update user set host='%' where user='root'请改为'root'@'%' 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ABCabc123!'; //更新用户密码


FLUSH PRIVILEGES;