进入mysql依次执行下面语句
修改远程访问 %
, 本地访问改为localhost
ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; #更新密码
FLUSH PRIVILEGES; #刷新权限
alter user 'root'@'%' identified by 'newPassword';#重置新密码