Skip to main content

Database permissions

in Instance Problems
Authors list
Published: 2023년 1월 26일|Last updated: 2023년 1월 26일

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.

도움이 되었습니다Unhelpful

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.