Loading...

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

when you trying to backup mysql using the command

mysqldump -u root -p  database_name > backup.sql

but it is throwing an error:

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

You just to need add --no-tablespaces

mysqldump -u root -p database_name > backup.sql --notablespaces

Share this Post: