title: How to revoke access to *.* for new user in mysql?
body: <p>In mysql 5.6 command line client (when logged in as root), i created a user with:</p>
  
  <pre><code>CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
  </code></pre>
  
  <p>Then granted privileges with:</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON databasename.* TO 'admin'@'localhost';
  </code></pre>
  
  <p>When checking privileges with:</p>
  
  <pre><code>SHOW GRANTS FOR 'admin'@'localhost';
  </code></pre>
  
  <p>Privileges for the assigned database above are showing as well as one for:</p>
  
  <pre><code>GRANT USAGE ON *.* TO 'admin'@'localhost' IDENTIFIED BY PASSWORD...
  </code></pre>
  
  <p>I tried to revoke privilege with:</p>
  
  <pre><code>REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'admin'@'localhost';
  </code></pre>
  
  <p>But it does not remove the usage on <code>*.*</code></p>
  
  <p>How do i revoke access to <code>*.*</code> for new user in mysql?  </p>