How Do I Change the Destination Database Password to Meet the Password Policy?
Scenarios
When you set the password for the migration account in the destination database, you need to set the password based on the password strength requirements of the destination database.
Procedure
The following operations apply to the scenario where the target database is an RDS instance.
- Log in to the RDS console.
- Locate the target DB instance.
- Click the DB instance name.
- On the Basic Information page, click the Parameters tab.
- Enter the keyword password in the search box in the upper right corner of the page and press Enter to view the search result.
Figure 1 Modifying parameters
- In the search result in 5, change the values of the parameters listed in Table 1 based on the password strength requirements. Ensure that the parameter values are within the password complexity range.
Table 1 Password description Parameter
Allowed Value
Description
validate_password_length
0-2,147,483,647
Specifies the minimum password length verified by the validate_password plugin.
validate_password_mixed_case_count
0-2,147,483,647
Specifies the minimum number of lowercase and uppercase letters in a password when the password policy level is MEDIUM or higher.
validate_password_number_count
0-2,147,483,647
Specifies the minimum number of digits in a password when the password policy level is MEDIUM or higher.
validate_password_policy
LOW, MEDIUM, STRONG
Specifies the password policy executed by the validate_password plugin.
validate_password_special_char_count
0-2,147,483,647
Specifies the minimum number of non-alphanumeric characters in a password when the password policy level is MEDIUM or higher.
- After the parameter values are modified, save the modification.
Figure 2 Modification result
- Back to the Select Migration Type page and perform the next step.
General Operations FAQs
- What Can I Do When Information Overlaps on the DRS Console?
- Is the Destination Instance Set to Read-only or Read/Write?
- How Do I Set Global binlog_format=ROW to Take Effect Immediately?
- How Do I Set binlog_row_image=FULL to Take Effect Immediately?
- How Do I Change the Destination Database Password to Meet the Password Policy?
- How Do I Configure the Shard Key for a MongoDB Sharded Cluster?
- Does Bandwidth Expansion Affect the Running DRS Tasks?
- Why Data in MariaDB and SysDB Cannot Be Migrated or Synchronized?
- Constraints and Operation Suggestions on Many-to-One Scenario
- Constraints and Operation Suggestions on One-to-Many Scenario
- Where Can I View DRS Operation Logs?
- Why Is the Language of the Message Sent by DRS Inconsistent with That on the Page?
- Why Is a DRS Task Automatically Stopped?
- How Can I Export a DRS Task List?
- Can a Completed Task Be Restarted?
- What Are the Differences Between Resetting a Task and Recreating a Task?
- Does DRS Support Backward Migration/Synchronization?
- Why Cannot I Select an Existing SMN Topic?
- Can I Change an SMN Topic After a Task Is Created?
- How Do I Set the Number of Source Shards and Source Database Information When DDM Is the Source Database?
- Will Data of DRS Tasks Be Lost After a Primary/Standby Switchover Occurs on the Source MySQL Database?
- What Are the Differences Between All, Tables, and Databases During DRS Object Selection?
- What Do I Do After Changing the Password of the Source or Destination Database?
- How Do I Configure an SMN Topic Policy to Allow DRS to Publish Messages?
- What Can I Do If a DRS Task Times Out Due to Too Many Tables?
- Can I Change the Source or Destination Database After a DRS Task Is Created?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore