Note that PROCESS is a global level privilege. To grant the PROCESS privilege, log in as an administrator user and run the following query: You should therefore really only use this option for your own local development server installation. Keep in mind that this option presents security issues. Granting the PROCESS privilege for the user is perhaps the simplest option for fixing the mysqldump process privilege error.

Runing mysqldump with the -no-tablespaces option.

Updating the privileges for your database user.

You can solve the mysqldump process privilege error in two ways: The last PROCESS privilege is new as of MySQL 5.7.31 and MySQL 8.0.21 and may be the root source of your problem.

PROCESS if you don’t use the -no-tablespaces option.

LOCK TABLES if you don’t use the -single-transaction option.

The mysqldump command requires at least the following privilege assigned to the user: Solutions for fixing the mysqldump process privilege error My script uses WP-CLI to export a database dump file and deploy it to a remote server. In my case, I encountered the problem when running a routine Python script for a Drupal to WordPress migration client. This error appears when running mysqldump directly from the command line, exporting the database using a client like MySQL Workbench or if you’re managing the WordPress database through WP-CLI’s export command. Users who do not need to dump tablespace information can work around this requirement by invoking mysqldump with the -no-tablespaces option. 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.

Incompatible Change: Access to the INFORMATION_SCHEMA.FILES table now requires the PROCESS privilege. You were able to export database before so what caused this? Here’s the answer: updates for MySQL 5.7.31 and MySQL 8.0.21 in July 2020 introduced an incompatible change: Mysqldump: Error: 'Access denied you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces You may receive a new ‘Access denied’ error when trying to dump your MySQL database: How to fix the mysqldump process privilege error after applying a recent MySQL update.

Tableplus export database