MySQL8.0报错Client does not support authentication protocol requested by server; consider upgrading My
程序员文章站
2022-06-12 22:30:33
...
首先输入:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
接下来设置密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';
最后刷新:
FLUSH PRIVILEGES;
记得编码格式:
?useUnicode=true&characterEncoding=utf8
上一篇: Table does not support optimize, doing recreate + analyze instead
下一篇: MySql 链接报错“Client does not support authentication protocol requested by server; consider upgradin”
推荐阅读
-
[error] [mysql] 1251 - Client does not support authentication protocol requested by server
-
本地安装Mysql后,navicat链接异常:Clinet dose not support authentication protocol request by server ; consider upgrading MySQL client
-
mysql Client does not support authentication protocol requested by server; consider upgrading MySQL
-
解决Navicat连接MySQL时“Client does not support authentication protocol requested by server; consider upgrading MySQL client”的问题
-
连接8.0.15mysql 报错 client does not support authentication protocol requested by server ,consider upgra
-
nodejs连接mysql报错:Client does not support authentication protocol requested by server; consider upgrad
-
MySQL8.0报错Client does not support authentication protocol requested by server; consider upgrading My
-
MySql 链接报错“Client does not support authentication protocol requested by server; consider upgradin”
-
node连接数据库报错Client does not support authentication protocol requested by server; consider upgrading M
-
关于nodejs报错Client does not support authentication protocol requested by server; consider upgrading My