Symptoms
Trying to run mysqldump as a MySQL virtual user(i.e. WordPress db user) will result in the error:
[user@server ~]# mysqldump -u cptest_wp -p cptest_wp > testing.sql
Enter password:
mysqldump: Error: 'Access denied; you need (at least one of) the
PROCESS privilege(s) for this operation' when trying to dump tablespaces
Description
This error occurs when the database requires the "PROCESS" privilege and the user making the backup does not have that privilege. "PROCESS" is not a privilege grantable through the cPanel interface, and must be given through the command line. As such, users created entirely within the cPanel interface will not have this privilege.
This is related specifically to the update of mysql-community packages to version 5.7.31, often occurring during regular cPanel updates.
Workaround
You can add the "PROCESS" privilege to the user creating the database dump, which will grant it the appropriate privileges to perform the operation. The username and hostname variables must be updated before running the commands below.
Please note that this action must be done as root, and should be performed by a System Administrator to ensure the commands are run correctly:
mysql mysql -e "GRANT PROCESS ON . TO ${username}@'localhost'; flush privileges;"
mysql mysql -e "GRANT PROCESS ON . TO ${username}@'$(hostname)'; flush privileges;"
Comments
1 comment
Update: We would like to thank you for your interest in this article/case and encourage your submissions as they are valuable to the ever-expanding development of cPanel & WHM. At this time, this particular issue has not been selected for action from our Development Team, as it may require more development resources than we can allot, or alters the direction cPanel envisions for the product. Submissions persist in our Issue Tracking System in the event the impact of the related issue grows or product direction changes. If you feel that this defect requires direct action, we strongly encourage you to submit a Feature Request to allow the cPanel Community to vote and support your cause.
Thank you again for helping us make cPanel & WHM the hosting platform of choice.
Article is closed for comments.