Help Center/ Data Replication Service/ FAQs/ Product Consulting/ How Do I Migrate Accounts in MySQL Migration, Synchronization, and DR Tasks and Can I Change Passwords?

Updated on 2023-07-03 GMT+08:00

View PDF

How Do I Migrate Accounts in MySQL Migration, Synchronization, and DR Tasks and Can I Change Passwords?

MySQL real-time migration: You can choose whether to migrate accounts when creating a migration task. For details, see Migrating Accounts. If the source and destination databases are of the same major version and the entire instance is migrated, DCL statements can be migrated in incremental mode, but users cannot be changed by updating the mysql.user table.
MySQL real-time synchronization: Accounts cannot be synchronized.
MySQL real-time DR: Accounts that have operation permissions on user-defined objects in the system database cannot be used for DR. DR objects cannot be selected. In the DR phase, DCL statements are supported, but accounts cannot be changed by updating the mysql.user table.

Parent topic: Product Consulting

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel