mysql 权限问题

CREATE USER jskjg IDENTIFIED BY 'jskjg';
GRANT ALL ON jskjg.* TO 'jskjg'@'%';
GRANT ALL ON jskjg.* TO 'jskjg'@'localhost';
flush privileges;

如上建立了jskjg用户后，仍然发生

# mysql -h localhost -u jskjg -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'jskjg'@'localhost' (using password: YES)

原因：

http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw

解决：

删除匿名用户''@'localhost' or ''@'127.0.0.1'.