Error Reported During Login to a DB Instance Through DAS

Scenario

The following error is reported when user root is used to log in to an RDS for MySQL instance on the DAS console: Client does not support authentication protocol requested by server. plugin type was = 'sha256_password'.

Possible Causes

DAS does not support login of database accounts using sha256_password for password encryption.

Solution

Run the following statement to change the password encryption mode to mysql_native_password:

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