title: MySQL: What does % stand for in host column and how to change user's password
body: <p>Well, this is what I can see: </p>
  
  <pre><code>select host, user from mysql.user;
  
  +-----------+------------------+
  | host      | user             |
  +-----------+------------------+
  | %         | me               |
  | 127.0.0.1 | root             |
  | ::1       | root             |
  | localhost |                  |
  | localhost | debian-sys-maint |
  | localhost | root             |
  | ubuntu    |                  |
  | ubuntu    | root             |
  +-----------+------------------+
  </code></pre>
  
  <p>I entered as root and would like to change password for user 'me'.</p>
  
  <pre><code>SET PASSWORD FOR 'me'@'%' = PASSWORD('letmein');
  Query OK, 0 rows affected (0.00 sec)
  </code></pre>
  
  <p>Well, no rows affected as we can see.</p>
  
  <p>As for trying to access, the result is as follows:</p>
  
  <pre><code>Access denied for user 'me'@'localhost' (using password: YES)
  michael@ubuntu:/var/www/cgi-bin$ 
  </code></pre>
  
  <p>So, it mentions localhost, not %. </p>
  
  <p>Could you suggest me how to change the password for 'me' and explain what % is?</p>