FAQ about connecting instances to DAS

FAQ

• Q: How do I connect a target instance to DAS and grant permissions?

  A: For detailed instructions, see Connect a database instance.

• Q: What are the minimum permissions required for different database engines?

  A: See Permissions.

• Q: Does DAS support connecting a self-managed MySQL instance using a root account?
  A: No. DBGateway requires the host IP address to connect to the database. However, a MySQL root account typically allows connections only from localhost or 127.0.0.1. Therefore, DAS does not support connecting a self-managed MySQL instance using a root account.

  Note To follow the least privilege principle and ensure account isolation, we recommend that you use a separate account to connect your self-managed MySQL instance.
• Q: Does DAS support connecting a self-managed Redis instance without a password?

  A: Yes. When DBGateway discovers an instance, it attempts to connect to the database. If your Redis account has no password, the instance status automatically changes to Normal Connection.

• Q: Why does an authentication failure occur when I grant permissions to an instance?
  A: Authentication failures are usually caused by one of the following:

  • Account not found: When you grant permissions in the DAS console, enter the database login account, not your Alibaba Cloud account.
  • Wrong password: Verify the database account's password.
  • Database access restrictions: If you use an existing database account to grant permissions to the target instance, check for database access restrictions, such as an IP whitelist.