Skip to main content

Database permissions

in Instance Problems
Authors list
Published: Jan 26, 2023|Last updated: Jan 26, 2023

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.

Warning

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.

HelpfulUnhelpful

0 of 1 people found this page helpful

next pageCron is paused
previous pageElasticsearch Index Tenancy

Please log in or register to submit a comment.