新版本不支持password函数
update mysql.usersetpassword=PASSWORD('123456')whereuser='root';不支持
update user set password=password('123456') where user='root';不支持
set password for 'root'@'localhost'=password('123');不支持
支持：alter user 'root'@'localhost' identified by '123';
另外8之后的加密规则也不一样
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
FLUSH PRIVILEGES; #刷新权限
解决navicat报1521的错误
