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

Home » MySQL » Fixed mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces
November 30, 2019 MySQL
Fixed mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

Error when export data base

Once at time on the blog pages, we already considered export/import large files to MySQL. Sometime, if this operations does on the customer side and you have limited rights there, you can faced with error:

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

Solution is very simple 🙂 Moreover solution we can found in the error text.

Problem: How to fix mysqldump error?

Solution: Just add option --no-tablespaces to command, for example:

mysqldump --no-tablespaces -h localhost -u database_name -p user_name > /path/to/file/data_base.sql

Sources:

  1. https://anothercoffee.net/how-to-fix-the-mysqldump-access-denied-process-privilege-error/

Related posts