title: Cannot log in with created user in mysql
body: <p>Using this command</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON *.* to 'brian'@'%' identified by 'password';
  </code></pre>
  
  <p>I try to login with:</p>
  
  <pre><code> mysql -u brian -ppassword
  </code></pre>
  
  <p>The error is:</p>
  
  <pre><code>ERROR 1045 (28000): Access denied for user 'brian'@'localhost' (using password: YES)
  </code></pre>
  
  <p>I am doing this as root and I did try to flush privileges.</p>
  
  <p>I tried this with countless users but it does not seem to work. I can create a user with no password and login works. Command line and from phpmyadmin</p>
  
  <p>Also check to see if the user was in mysql.user which it is.</p>
  
  <p>Show grants for brian shows:</p>
  
  <pre><code>| GRANT ALL PRIVILEGES ON *.* TO 'brian'@'%' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' |
  </code></pre>