RDS解决Client does not support authentication protocol requested by server； consider upgrading MySQL

阿里云RDS解决报错Client does not support authentication protocol requested by server; consider upgrading MySQL client

本地Navicat连接报错：

解决方案：
登录阿里云RDS数据库（也可本地MYSQL远程登录进入修改，这里本地没装MYSQL）
输入以下命令：

//引号中的password为需要设置的密码，不改即写原来的；brendon为用户名。
alter user 'brendon'@'%' identified by 'password' password expire never;
flush privileges;

以上操作即可解决Client does not support authentication protocol requested by server; consider upgrading MySQL client报错。

注意：命令一旦执行成功，就必须退出登录，重新用新密码登录进去操作，否则继续操作会提示Access Denied。