title: MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)
body: <p>First let me mention that I've gone through many suggested questions and found no relevent answer. Here is what I'm doing.</p>
  
  <p>I'm connected to my Amazon EC2 instance. I can login with MySQL root with this command:</p>
  
  <pre><code>mysql -u root -p
  </code></pre>
  
  <p>Then I created a new user bill with host % </p>
  
  <pre><code>CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass';
  </code></pre>
  
  <p>Granted all the privileges to user bill:</p>
  
  <pre><code>grant all privileges on *.* to 'bill'@'%' with grant option;
  </code></pre>
  
  <p>Then I exit from root user and try to login with bill:</p>
  
  <pre><code>mysql -u bill -p
  </code></pre>
  
  <p>entered the correct password and got this error:</p>
  
  <blockquote>
    <p>ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)</p>
  </blockquote>