SQLyog连接linux数据库问题
SQLyog连接linux数据库报错解决办法
·
使用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;
更多推荐
已为社区贡献1条内容
所有评论(0)