Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database User Permissions/ Checking Whether the Destination Database Account Has Required Permissions to Migrate Definer
Updated on 2023-02-15 GMT+08:00

Checking Whether the Destination Database Account Has Required Permissions to Migrate Definer

MySQL Migration

Table 1 Checking Whether the Destination Database Account Has Required Permissions to Migrate Definer

Check Item

Checking whether the destination database account has required permissions to migrate Definer

Description

To migrate Definers to the cloud, the source database user must have the all privileges permission.

Failure Cause and Handling Suggestion

Failure cause: The permission of the specified destination database account is insufficient.

Handling suggestions: Migrate all Definers to the specified destination database account. Alternatively, do not migrate Definers to the specified destination database account and run the following command to grant the destination database account the all privileges permission.

Example command:

grant all privileges on *.* to 'user' @' host'

Failure cause: The specified source database user does not have required permissions.

Handling suggestion:

  1. When configuring the destination database, select Migrate Definer to User to ensure that Definers of all the objects are under the specified user.
  2. Retain the Definer settings and run the following command to grant the all privileges permission to the source database user.

    Example command:

    grant all privileges on *.* to 'user' @' host'