Navicat 连接MySQL 8.0.11 出现2059错误

admin

https://www.cnblogs.com/lifan1998/p/9177731.html

mysql -uroot -ppassword #登录
use mysql; #选择数据库
# 远程连接请将'localhost'换成'%'

ALTER USER 'BobDylan'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #更改加密方式

ALTER USER 'BobDylan'@'%' IDENTIFIED WITH mysql_native_password BY '******'; #更新用户密码

FLUSH PRIVILEGES; #刷新权限