title: grant file on just one database
body: <p>I want to allow LOAD DATA command for the john mysql user.  So I logged into mysql terminal as root and issued the following statement:</p>
  
  <pre><code>grant file on johndatabase.* to 'john'@'localhost';
  </code></pre>
  
  <p>But I got the following error:</p>
  
  <pre><code>ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
  </code></pre>
  
  <p>If I replaced <code>johndatabase.*</code> with <code>*.*</code>, then everything works.  But doesn't <code>*.*</code> mean all databases?   I want to limit the john mysql user to just johndatabase.</p>