在安装mysql8的时候如果选择了密码加密,之后用客户端连接比如navicate,会提示客户端连接caching-sha2-password,是由于客户端不支持这种插件
#修改加密规则
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
#更新密码(mysql_native_password模式)
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘{NewPassword}’;
mysql8 :nacicat caching-sha2-password问题
最新推荐文章于 2024-06-06 22:32:52 发布