All Products
Search
Document Center

"running with the --rds-deny-access option" error reported when you use DMS to connect to RDS

Last Updated: Feb 25, 2021

Description

this topic describes how to resolve the following errors when you use DMS to connect to an RDS instance. $End3

The MYSQL server is running with the --rds-deny-access option so it cannot execute this statement

Causes

Generally, an RDS instance is locked due to the following reasons:

  • The RDS instance expires.

  • The disk of the RDS instance is full.

solution

  1. Log in to the Ali Cloud RDS console instance list page.

  1. Check whether the RDS instance is locked.

  1. If the RDS instance is locked due to expiration, you must renew the instance and unlock the instance.

  1. If an RDS instance is locked due to full disk, you must upgrade its disk to unlock the instance.

  2. Try to connect to the RDS instance by using DMS again after unlocking the RDS instance.

Applicability

  • Data Management (DMS)

  • RDS