주 콘텐츠로 건너뛰기

Database permissions

Instance Problems에서
저자 리스트
발표됨: 2023년 1월 26일|최종 업데이트됨: 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.

도움이 되었습니다도움이 되지 않음

이 페이지가 도움이 된다고 생각하는 사람들의 수 0 / 1

다음 페이지Cron is paused
이전 페이지Elasticsearch Index Tenancy

댓글을 작성하려면 로그인하거나 등록하셔야 합니다.