MySQL8.0设置远程访问权限，Navicat连接mysql

#查看root用户权限

SELECT `user`, `host`, `authentication_string`, `plugin` FROM mysql.user;

#添加远程访问权限
update user set host='%' where user='root';

#修改mysql加密规则

ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

#刷新权限
FLUSH PRIVILEGES;