title: Are Users 'User'@'%' and 'User'@'localhost' not the same?
body: <p>I created a user per the first command but cannot logon via localhost (linux).    This link <a href="http://forums.mysql.com/read.php?101,304823,305463#msg-305463">mysqldoc</a> indicates that I need to create a second user by the same name, but using the syntax in the second block of commands.</p>
  
  <pre><code>mysql&gt; CREATE USER 'myuser'@'%' IDENTIFIED BY '4myuser';
  Query OK, 0 rows affected (0.00 sec)
  
  mysql&gt; GRANT ALL ON my_upload.* TO 'myuser'@'%' IDENTIFIED BY '4myuser';
  Query OK, 0 rows affected (0.00 sec)
  </code></pre>
  
  <p>So I tried that as below, and it indeed worked.  But are these two separate users?  If I change the pw for one, will the other one sync, or are they truly separate users?</p>
  
  <pre><code>mysql&gt; CREATE USER 'myuser'@'localhost' IDENTIFIED BY '4myuser';
  Query OK, 0 rows affected (0.00 sec)
  
  mysql&gt; GRANT ALL PRIVILEGES ON my_upload.* TO  'myuser'@'localhost';
  Query OK, 0 rows affected (0.00 sec)
  </code></pre>