Skip to main content

WPToolkit error during backup: "mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces"

JC Newton
  • Updated

Symptoms

Attempting to make a backup of a site with WP Toolkit presents the below error:

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s)
for this operation' when trying to dump tablespaces

Description 

It was recently discovered that databases with special functions in MySQL 8.0 fail to backup. This is due to a change in MySQL 8.0 when handling specific types of data. The MySQL documentation states the following: 

Incompatible Change: Access to the INFORMATION_SCHEMA.FILES table now requires the PROCESS privilege.

 

This change affects users of the mysqldump command, which accesses tablespace information in the FILES table, and thus now requires the PROCESS privilege as well. Users who do not need to dump tablespace information can work around this requirement by invoking mysqldump with the --no-tablespaces option. (Bug #30350829)

This issue has been reviewed by the WP Toolkit developers and assigned case ID EXTWPTOOLK-8196. We recommend following this article to receive an email notification when a solution is published in the product.

Workaround

This error is specific to users created under cPanel accounts, for use with applications ( such as DB_USER variable in wp_config.php, in WordPress ).  To perform the mysql database dump, use the -u and -p options for mysqldump, and specify a user such as the cPanel account username, or root. 

Alternatively, cPanel's Backup Wizard or phpMyAdmin can be used to take backups of the databases until the WP Toolkit developers release a solution for this issue.

Related articles