新版本不支持password函數(shù)
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之后的加密規(guī)則也不一樣
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密規(guī)則
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用戶(hù)的密碼
FLUSH PRIVILEGES; #刷新權(quán)限
解決navicat報(bào)1521的錯(cuò)誤
