tencent cloud

All product documents
Data Transfer Service
DocumentationData Transfer ServiceData MigrationMigration to MySQL SeriesProcessing for MySQL Series Pre-Check FailureTarget Instance Permission Check
Target Instance Permission Check
Download PDF
Last updated: 2024-07-11 15:03:48
Target Instance Permission Check
Last updated: 2024-07-11 15:03:48
Download PDF

Check Details

1. Check whether the user has permission to operate the database. In migration/synchronization/subscription processes, each database type has detailed permission requirements. See corresponding guidance.
2. For the target end being MySQL versions 8.0.26 and later, DTS will check the innodb_strict_mode parameter. It is recommended that innodb_strict_mode be set to OFF during migration/synchronization tasks. If it is not set to OFF, DTS will give a prompt during the pre-verification. For MySQL versions earlier than 8.0.26 or other database types, DTS will modify this parameter at the session level to OFF.
Parameter Description: innodb_strict_mode controls whether the InnoDB storage engine enables strict mode for improper data.
innodb_strict_mode=ON: The InnoDB storage engine will perform strict data validation. If there are syntax errors during operations like CREATE TABLE, ALTER TABLE, and CREATE INDEX, it will throw an error directly.
innodb_strict_mode=OFF: The InnoDB storage engine relaxes data validation. The above syntax errors will not trigger an error, and default syntax will be used instead.
Setting recommendation: If the source database contains improper data, it is recommended that the innodb_strict_mode parameter be set to OFF during migration/synchronization tasks. This will allow data to be synchronized normally to the target.

Fixing Solution

If the user does not have the required permissions, grant the corresponding permissions as specified in the check requirements, then re-run the verification task.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon