All Products
Search
Document Center

ApsaraDB RDS:What do I do if the "ERROR 1044 (42000): Access denied for user 'xxxx'@'%' to database 'xxxx'" error message is displayed when I create a database on an ApsaraDB RDS for MySQL instance?

Last Updated:Nov 24, 2023
By default, a standard account for an ApsaraDB RDS for MySQL instance has only the permission to log on to databases. If you want to use the standard account to create a database, you must first use the privileged account to grant the CREATE permission to the standard account. Example statement:
GRANT CREATE ON *.* TO '<Name of the standard account>'@'%';

For more information, see Modify the permissions of a standard account on an ApsaraDB RDS for MySQL instance.