连接阿里云本地mysql使用druid数据库连接池出现Client does not support authentication protocol requested by server

问题描述：

阿里云使用tomcat部署项目时，数据库连接池无法连接到阿里云本地的mysql数据库
项目环境是tomcat 8.5.37
mysql 5.7.35-0ubuntu0.18.04.1 (Ubuntu)

---

原因分析：

查看mysql的log发现控制台报错

15-Sep-2021 18:54:51.959 SEVERE [http-nio-8080-exec-1] com.alibaba.druid.pool.DruidDataSource.error init datasource error, url: jdbc:mysql://localhost:3306/bank?useUnicode=true&characterEncoding=utf-8&userSSL=false
	com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

---

解决方案：

1. 进入mysql，使用mysql数据库,修改用户的密码为native密码（旧的加密规则）

use mysql;
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
flush privileges;
quit

2. 重启mysql

service mysql restart