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


Posted on by TheKorko

When using mysqldump:

mysqldump -u root -p  database_name > backup.sql

You can get the error from the title

use --no-tablespaces

see mysqldump-Documentation

mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, LOCK TABLES if the –single-transaction option is not used, and (as of MySQL 8.0.21) PROCESS if the –no-tablespaces option is not used. Certain options might require other privileges as noted in the option descriptions.

and see documentation of param no-tablespaces

–no-tablespaces, -y

This option suppresses all CREATE LOGFILE GROUP and CREATE TABLESPACE statements in the output of mysqldump.

Fix:

mysqldump -u root -p database_name > backup.sql --no-tablespaces

https://dba.stackexchange.com/questions/271981/access-denied-you-need-at-least-one-of-the-process-privileges-for-this-ope

Posted in Programming

About this user: TheKorko

This is my website!

This is a random placeholder text.

View user profile. TheKorko

0 thoughts on “‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces”