解决navcat无法远程连接mysql8.0

1、设置远程连接

连接服务器: mysql -u root -proot

进入mysql数据库：use mysql;

修改user表中的Host:update user set Host='%' where User='root';

最后刷新一下：flush privileges;

mysql -u root -proot
use mysql;
update user set Host='%' where User='root';
flush privileges;

2解决mysql8密码加密乱码问题

mysql -uroot -proot
use mysql;
ALTER USER 'root'@'%' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;