我在mysql终端尝试了以下语句:
revoke file on *.* to 'john'@'localhost';
但是我遇到了错误:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to 'john'@'localhost'' at line 1
什么是revoke语句的正确语法?我尝试阅读MySQL文档,但没有理解。