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.

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

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/

Leave Comment

Your email address will not be published.