mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
empiricompany opened this issue · 2 comments
empiricompany commented
default db:dump on centos 8 / percona server 5.7 return this error:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
i have to add "process" privilage to mysql user or pass extra option --no-tablespaces to mysqldump to avoid the error
db:dump --dump-option="--no-tablespaces"
we can add --no-tablespaces option by default in mysqldump command?
nice explatation of tablespaces
https://anothercoffee.net/how-to-fix-the-mysqldump-access-denied-process-privilege-error/
cmuench commented
@empiricompany for n98-magerun2 we have already a solution for that issue.
We need to backport that feature.
The solution is a --no-tablespaces option.
empiricompany commented