title: SHOW GRANTS displays there is no such grant defined for user
body: <p>I have a user that is currently running my MySQL database. I wanted to see the rights that user has by executing the following:</p>
  
  <pre><code>SHOW GRANTS FOR 'myuser'@'localhost';
  </code></pre>
  
  <p>and I got</p>
  
  <pre><code>ERROR 1141 (42000): There is no such grant defined for user 'myuser' on host 'localhost'
  </code></pre>
  
  <p>Shouldn't I see some permissions for that user since it's currently being used to read/write></p>
  
  <p><em>Edit:</em> When I run the following query to see the hostname associated with the user, it returns <code>%</code> as the host.</p>
  
  <pre><code>select host from mysql.user where user = 'myuser';
  </code></pre>