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;