修改root命令
alter user 'root'@'%' identified by 'xxxxx';
导航猫连接不上mysql 8以上是因为密码加密不同,可以用语句修改加密方式后再次连接:
alter user '用户'@'%' identified with mysql_native_password by '密码';
ALTER USER '用户'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;
修改root命令
alter user 'root'@'%' identified by 'xxxxx';
导航猫连接不上mysql 8以上是因为密码加密不同,可以用语句修改加密方式后再次连接:
alter user '用户'@'%' identified with mysql_native_password by '密码';
ALTER USER '用户'@'localhost' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;