sqlog连接mysql报错

问题 @

sqlog连接mysql报错

解决方案 @

新版本mysql使用caching_sha2_password验证方式，原来是mysql_native_password

mysql -uroot -p 
进入mysql依次执行下面语句
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; #修改密码加密策略
flush privileges;     #刷新权限
# 重置密码
alter user 'root'@'localhost' identified by '123456';