Insufficient Permissions During Data Export Using mysqldump
Case 1
When you export database data with mysqldump using a specified user account, the error message "Access denied; you need (at least one of) the PROCESS privilege(s)" is displayed.
- Cause analysis: The user used to export data does not have the PROCESS privilege.
- Solution: Use the administrator account to grant the PROCESS privilege to the user.
GRANT SELECT, PROCESS ON *.* TO '<username>'@'%';
FLUSH PRIVILEGES;
Case 2
The error message "Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227)" is displayed when mysqldump is used to export data.
- Cause analysis: The user used to export data does not have the RELOAD privilege.
- Solution: Use Data Admin Service (DAS) to grant the RELOAD privilege to the user.
GRANT RELOAD ON *.* TO '<username>';
FLUSH PRIVILEGES;
Case 3
The error message "Access denied; you need (at least one of) the LOCK TABLES privilege(s) for this operation (1227)mysqldump" is displayed when mysqldump is used to export data.
- Cause analysis: The user used to export data does not have the LOCK TABLES privilege.
- Solution: Grant the LOCK TABLES privilege to the user.
GRANT LOCK TABLES ON DATABASE.* TO '<username>';
FLUSH PRIVILEGES;
Parent topic: Backup and Restoration Issues
- Case 1
- Case 2
- Case 3