For more information, see Access an ApsaraDB for RDS instance and Access an ECS-based user-created database instance.
No, you cannot use the root account to access a user-created MySQL database from DAS.
DBGateway requires that the IP address used to access the database is that of the host machine. However, the root account of a user-created MySQL database typically allows access only from the IP address of localhost or 127.0.0.1. Therefore, you cannot access the user-created MySQL database from DAS by using the root account.
In order to implement the least privilege principle and account isolation, we recommend that you use a separate account to access user-created MySQL databases from DAS.
Yes, you can access user-created Redis databases without providing the account password.
When DBGateway detects a database instance, it will attempt to establish a connection to the database. If the account used to log on to the Redis database has no password, the status of the instance will automatically change to Accessed.
Why am I prompted that the authentication failed when I authorize a RAM user to access a database instance?
An authentication failure may occur due to one of the following causes:
- The account does not exist
When you grant permissions to a RAM user in the DAS console, use the account used to log on to the target database instead of the Alibaba Cloud account.
- The password is incorrect
Use the correct password of the account used to log on to the target database.
- The access to the database is denied
To authorize an existing database account to access the target database, you must check the access control settings of the target database.