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 @'%' <