ERROR 1045 (28000): Access denied for user 'openfire'@'localhost' (using password: YES)
mysql -u root -p
Then I created a new user bill with host %
CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass';
Granted all the privileges to user bill:
grant all privileges on . to 'bill'@'%' with grant option;
Then I exit from root user and try to login with bill:
mysql -u bill -p
entered the correct password and got this error:
ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)
错误原因:
mysql.user表中存在一条user=''的记录,导致登录时首先匹配到这条记录,所以无法登录。
解决办法:
删除掉这条用户记录,即操作语句:DELETE FROM mysql.user where user='';
--转自