Hi - I run a nightly cron job to back-up to backup my SQL databases using mysqldump.
This has started to display the following error on all my databases:
Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
One of the solutions for this is to run the mysqldump using the --no-tablespace option.
Is this a safe practice, and recommended practice, to implement with Magento 2 databases?
Hi - the job is defined in the cron tab of the user's cPanel.
I get the same error if run the backup script from SSH using the user login and the root login.
All privileges are assigned to the database for the user.
This script ran fine for about 5 years. I don't think the version of SQL has updated. We are still running v5.6.49.
My understanding is that the tablespaces are reliant on a global privilege and not a user privilege.