服务以前连接mysql5.7,现在连接mysql8报错
1
2
3
4
|
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlState: '08004',
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
|
原因：
mysql5.7 认证默认是mysql_native_password，mysql8默认是caching_sha2_password
解决方式：
- 创建数据库时，指明
mysql_native_password
1
|
docker run -d --name mysql8 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -v mysql8:/var/lib/mysql mysql:8.0 --default-authentication-plugin=mysql_native_password
|
- 修改数据库，将用户认证的
caching_sha2_password改为mysql_native_password
1
2
3
4
5
6
|
# $ mysql -u root -p
use mysql;
select host,user,plugin,authentication_string from mysql.user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
# ... 如果还有其他USER，把其他USER(mysql.sys,mysql.session,mysql.infoschema)也替换
flush privileges;
|
- 升级客户端，支持最新的认证
reference:
https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server
