Question

For REVOKE statements, the server automatically rereads the grant tables.

(a) True

(b) False

I have been asked this question in my homework.

This question is from Securing a New MySQL Installation topic in section General MySQL Administration of MySQL

Answer 1

The correct option is (a) True

To elaborate: For the ‘REVOKE’ and ‘DROP USER’ statements, the server automatically re-reads the grant tables and no FLUSH PRIVILEGES statements are needed. Hence the grant tables are re-read.