mysql用户

use mysql;

查看user表信息

select user,host from user;

查看登录用户名对应的host是否为“%”

否则修改为%

 

如果提示密码错误问题

修改密码加密模式

ALTER USER 'root'@'%' IDENTIFIED BY 'mysql  root密码' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新 root密码';

FLUSH PRIVILEGES;