HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlCritical

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thisdumptheprivilegeyouneedprocesstryingdeniedoperation

Problem

I am 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

Also, I wanted to make a backup my database with all tables seperately stored as a file. How can I do it?

mysql version = 5.7.31

Solution

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.

Context

StackExchange Database Administrators Q#271981, answer score: 296

Revisions (0)

No revisions yet.