Attempting to make a backup of a site with WordPress 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
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:
This change affects users of the mysqldump command, which accesses tablespace information in the
FILEStable, and thus now requires the
PROCESSprivilege as well. Users who do not need to dump tablespace information can work around this requirement by invoking mysqldump with the
--no-tablespacesoption. (Bug #30350829)
This issue has been reviewed by the WordPress 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.
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 WordPress Toolkit developers release a solution for this issue.