problems mysqldump: Error: ‘Access denied; you need (at least one of)

[sucre13]

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

I would like to know why I get this error when trying to make a backup by ssh

 

[sucre13]

soluction

This problem can occur if you are using cpanel terminal or SSH to export databases using mysqldump.

Command you probably use:
mysqldump -u [username] -p [database] > dump.sql

The Problem that occured:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

Solution:
add this parameter: --no-tablespaces

sample:
mysqldump --no-tablespaces -u [username] -p [database] > dump.sql