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

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

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

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'