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;

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;