linux宝塔安装mysql8.0，使用Navicat连接数据库失败解决

1、先连接数据库

mysql -u root -p

2、查询用户表命令，便于修改权限后对比

select User,authentication_string,Host from user;

3、给所有ip连接权限

CREATE USER root @'%' IDENTIFIED BY 'your password';
GRANT ALL PRIVILEGES ON *.* TO root @'%' WITH GRANT OPTION;

4、修改mysql8.0加密规则

ALTER USER 'root'@'localhost' IDENTIFIED BY 'your password' PASSWORD EXPIRE NEVER;
ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'your password';

6、查询用户表命令，查看修改后的权限

select User,authentication_string,Host from user;

7、开放端口
宝塔安全和服务器控制台防火墙放行mysql 3306端口，之后就可以使用Navicat连接数据库了。