MySQL: What does % stand for in host column and how to change user's password

You need to set password for localhost:

SET PASSWORD FOR 'me'@'localhost' = PASSWORD('letmein');

FLUSH PRIVILEGES;

% means remote hosts can login to MySQL server from any other server whereas localhost means you can login to MySQL server only from same machine.