Checking Whether the Destination Database User Has Sufficient Permissions
MySQL Migration
Check Item |
Whether the destination database user has sufficient permissions |
---|---|
Description |
Check whether the destination database user permissions meet the migration requirements. If the permissions are insufficient, the migration will fail. |
Failure Cause and Handling Suggestion |
Failure cause: The destination database user must have the following permissions: SELECT, CREATE, DROP, DELETE, INSERT, UPDATE, INDEX, EVENT, CREATE VIEW, CREATE ROUTINE, TRIGGER, and WITH GRANT OPTION. If the destination database version is in the range from 8.0.14 to 8.0.18, the SESSION_VARIABLES_ADMIN permission is required. Handling suggestion: Check whether the destination database user permissions meet the migration requirements. |
Failure cause: Insufficient user permissions Handling suggestion: Check whether the database user permissions meet the migration requirements. |
|
Failure cause: An internal error occurs. Handling suggestion: Contact technical support. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot