点击数：52

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; #更新一下用户的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
alter user 'root'@'localhost' identified by '你要改的密码';

授权远程访问

update mysql.user set host='%' where user='root' ;
FLUSH PRIVILEGES; #刷新权限