title: Mysql how to revoke file
body: <p>I tried the following statement in mysql terminal:</p>
  
  <pre><code>revoke file on *.* to 'john'@'localhost';
  </code></pre>
  
  <p>But I get the error:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>What is the correct syntax for the revoke statement?  I tried reading mysql documentation but didn't understand.</p>