Fix ‘mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s)…’

Description

This error occurs when excute following codes:

mysqldump -uuser_name -ppassword wordpress > ./wordpress.sql;

outputs:

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

Analysis

This error is related to MySQL permission mechanism.

Fix

mysql > GRANT PROCESS ON *.* TO 'user_name';