关于mysql grant权限语句的报错问题

Question

我用 mysql -u root -p
登陆进去敲入命令
grant all on . to ja identified by '123' with grant option;
提示Query OK, 0 rows affected (0.00 sec)

退出后，用刚新建的ja账号登陆
mysql -u ja -p

提示 ERROR 1045 (28000): Access denied for user 'ja'@'localhost' (using password: YES)

请问为啥？

Answer 1

需要刷新系統權限表[flush privilege] 該使用者才能生效登入

flush privileges;

Answer 2

如果是grant all on . to ja@localhost ...
的話，應該就不會報錯了

Answer 3

grant的指令格式為：mysql> grant all on . to 'user'@'ip' identified by 'password' with grant option;

Answer 4

grant all on . to 'ja'@'%' identified by '123' with grant option;
flush privileges;
quit;
然後再登入看看：mysql -u ja -p 123