All Products
Search
Document Center

What do I do if the "ERROR 1045 (28000): Access denied for user" error message is displayed when I connect to an ApsaraDB RDS for MySQL instance

Last Updated: May 19, 2022

Description

When you connect to an ApsaraDB RDS for MySQL instance, the following error message is displayed:

ERROR 1045 (28000): Access denied for user 'XXX'@'XXX' (using password: YES)

Cause

The username or password that you entered is invalid.

Solution

Take note of the following items:

  • Before you perform high-risk operations such as modifying the specifications or data of an Alibaba Cloud instance, we recommend that you check the disaster recovery and fault tolerance capabilities of the instance to ensure data security.
  • Before you modify the specifications or data of an Alibaba Cloud instance, such as an Elastic Compute Service (ECS) instance or an ApsaraDB RDS instance, we recommend that you create snapshots or enable log backups for an ApsaraDB RDS instance.
  • If you have granted specific users the permissions on sensitive information, such as logon accounts and passwords, or submitted sensitive information in the Alibaba Cloud Management Console, we recommend that you modify the sensitive information at the earliest opportunity.

Check the username and password of the connection information:

  • ApsaraDB RDS does not provide accounts that are equivalent to root accounts. If you need a root account, you must create one. For more information, see Create databases and accounts for an ApsaraDB RDS for MySQL instance.

  • If the password contains special characters, the special characters must be enclosed in single quotation marks (') For example, use -p 'XXX' in a command.

  • If you forget the password of the account that is used to connect to the RDS instance, log on to the ApsaraDB RDS console and go to the Accounts page of the RDS instance. Then, you can change the password of the account on the Accounts page.

    Note: After you change the password, the new password takes effect after a few minutes

References

If the following error message is displayed When you connect to an ApsaraDB RDS for MySQL instance, no password is specified in the connection information.

ERROR 1045 (28000): Access denied for user 'XXX'@'XXX' (using password: NO)

Application scope

  • ApsaraDB RDS for MySQL