Updated on 2023-02-02 GMT+08:00

Checking Whether the Source Database User Has Sufficient Permissions

MySQL Migration

Table 1 Checking whether the source database user has sufficient permissions

Check Item

Whether the source database user has sufficient permissions

Description

The source database user must have the required permissions.

  • In a full migration, the source database user must have the SELECT, SHOW VIEW, and EVENT permissions.
  • In an incremental migration, the source database user must have the following permissions: SELECT, SHOW VIEW, EVENT, LOCK TABLES, REPLICATION SLAVE, and REPLICATION CLIENT.

If the permissions are insufficient, the migration will fail.

Failure Cause and Handling Suggestion

Failure cause: In a full migration, the source database user must have the SELECT, SHOW VIEW, and EVENT permissions.

Handling suggestions: Grant the source database user the corresponding permissions.

Failure cause: In an incremental migration, the source database user must have the following permissions: SELECT, SHOW VIEW, EVENT, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT, In the DR scenario, the following permissions are required: CREATE, ALTER, DROP, DELETE, INSERT, UPDATE, and INDEX.

Handling suggestions: Grant the source database user the corresponding permissions.

Failure cause: Insufficient user permissions

Handling suggestion: Check whether the database user permissions meet the migration requirements.

NOTE:

Failure cause: An internal error occurs.

Handling suggestion: Contact technical support.