With the release of MySQL 8.0.32, the permissions required to perform a database backup have changed. Database users performing the back up are now required to have the FLUSH_TABLES
privilege.
The OPC will attempt to automatically grant this permission to your existing database user, but if this is unsuccessful, you will need to grant this permission manually with the following command:
GRANT FLUSH_TABLES ON *.* TO 'user'@'host'; copy
(You will need to replace 'user'@'host'
with the username and host of your database user)
This will then allow the OPC to continue to perform database backups.
If you are unable to grant this permission to your database user, database backups will likely fail.
In this case, we would highly recommend arranging an alternative backup solution.
Please log in or register to submit a comment.