关于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

You need to refresh the system permission table [flush privilege] before this user can log in effectively

flush privileges;

Answer 2

If you grant all on . to ja@localhost ...
, there should be no error

Answer 3

The command format of

grant is: 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;
then log in again Take a look: mysql -u ja -p 123