use mysql;ALTERUSER'root'@'localhost'IDENTIFIEDBY'password'PASSWORDEXPIRENEVER;//更改加密方式ALTERUSER'root'@'localhost'IDENTIFIEDWITH mysql_native_password BY'password';//更改密码FLUSHPRIVILEGES;//刷新
问题 cmd可以连上mysql但navicat连接报错 client does not support authentication protocol requested by server
问题描述: cmd可以连上mysql但navicat连接报错 解决方案:use mysql;ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;//更改加密方式ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; //更改密码FLUSH PRIVILEGES;//刷新...