在mysql中新建了數據庫，也建立了賬戶，按理說應該可以正常用新賬戶登錄數據庫的，因為以前一直這樣用都沒問題，但今天不行了。
CREATE DATABASE openfire DEFAULT CHARACTER SET 'UTF8';
GRANT ALL ON openfire.* TO openfire@'%' IDENTIFIED BY '123456';
FLUSH PRIVILEGES;
用mysql -uopenfire -p123456 openfire，報錯如下：
ERROR 1045 (28000): Access denied for user 'openfire'@'localhost' (using password: YES)
解決辦法：
刪除mysql中user為空的記錄
delete from user where user is null;
delete from user where user='';
FLUSH PRIVILEGES;
再登錄即可。