通过das登录实例报错client does not support authentication protocol requested by server-j9九游会登录

场景描述

在控制台以root账号通过das登录rds for mysql实例报错：client does not support authentication protocol requested by server. plugin type was = 'sha256_password'

原因分析

das暂不支持密码的加密方式为sha256_password的数据库用户登录。

j9九游会登录的解决方案

执行如下语句将密码的加密方式改为mysql_native_password。

alter user 'user_name'@'%' identified with mysql_native_password by 'password';