问题来源:
homebrew安装完mysql8后,需要做一些初始化配置,关于密码的配置如下:
There are three levels of password validation policy:
LOW Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary file
Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG:
大意为:密码策略有三个级别,需要设置密码策略级别;
我这里选择的是最低级别。
一路 "Y" 配置完成后,连接navicat客户端,发现连接失败:Client does not support authentication protocol requested by server;
网上查询之后,应该是密码策略太低的问题(加密策略?)
解决方案:
打开终端,输入如下
mysql -uroot -p
##输入密码
use mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你自己的密码';
FLUSH PRIVILEGES;
完美解决