patternsqlCritical
'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Viewed 0 times
thisdumptheprivilegeyouneedprocesstryingdeniedoperation
Problem
I am trying to backup mysql using the command
, 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
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
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.
--no-tablespacessee 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.