在mysql中新建了數(shù)據(jù)庫，也建立了賬戶，按理說應(yīng)該可以正常用新賬戶登錄數(shù)據(jù)庫的，因?yàn)橐郧耙恢边@樣用都沒問題，但今天不行了。
CREATE DATABASE openfire DEFAULT CHARACTER SET 'UTF8';
GRANT ALL ON openfire.* TO openfire@'%' IDENTIFIED BY '123456';
FLUSH PRIVILEGES;
用mysql -uopenfire -p123456 openfire，報(bào)錯(cuò)如下：
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;
再登錄即可。