In case we find this problem when trying to backup the Pandora FMS database with a user different from root
:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
It is necessary to add the PROCESS
permission to the user with which we are doing the dump.
GRANT PROCESS ON *.* TO user@localhost;