MySQL8 Public Key Retrieval is not allowed
Docker安装mysql8后,发现DBever和程序都连不到数据库,提示 Public Key Retrieval is not allowed
,确认密码无误后尝试试用命令行登录成功,而用命令行登录成功之后,DBever和程序就可以正常连接数据库了。
1 2
| use mysql; alter user 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password_here';
|
参考资料
https://stackoverflow.com/questions/50379839/connection-java-mysql-public-key-retrieval-is-not-allowed#
https://blog.csdn.net/qq_48234103/article/details/120769173