-1

I want o create a new MySQL user for logrotate and it needs to be able to run FLUSH LOGS, but doesn't need any other privileges as far as I can tell.

What is the minimum mysql privileges I need to give to this user in order to access FLUSH LOGS ?

I am using Mysql 5.7.29 if it matters.

adrianTNT
  • 3,671
  • 5
  • 29
  • 35

1 Answers1

2

According to Mysql 5.7.x docs for the FLUSH statement, you would need RELOAD privilege.

RELOAD privilege docs: https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_reload

FLUSH statement docs: https://dev.mysql.com/doc/refman/5.7/en/flush.html

Dejan
  • 78
  • 5