idea 无法连接数据库 mysql

Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unable to load authentication plugin 'caching_sha2_password'.)

数据库的配置等正常；

如何排除那呢？

参考下https://blog.csdn.net/zixiao217/article/details/80156362

用户登录失败.
楼主检查下用户名和密码