mysqldump error : access denied you need at least one of the process privilege(s) for this operation , solution

While dumping a mysql database , and if you receive the error :

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

A possible solution to fix this problem , is by using the --no-tablespaces option , so your database dump command , will look like this :

mysqldump --no-tablespaces -u user_name -p db_Name > backup_file.sql

Using --no-tablespaces option , will suppress CREATE LOGFILE GROUP , and CREATE TABLESPACE statements , in the generated dump . This is related to, the ndb cluster storage engine .