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.
0 kommentar(er)
