修改密码
ALTER USER "root"@"localhost" IDENTIFIED BY "你的新密码";
navicat连接mysql8.0.1版本出现1251--Client does not support authentication protocol requested by server的解决
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxx' //xxx为新密码
授权远程连接:
grant all on *.* to 'root'@'%';
刷新权限
FLUSH PRIVILEGES;