Question

mysql初学者error1064<42000>错误

登录后
mysql>GRANT select,insert,ON student.* TO YanBob@192.168.1.11
->IDENTIFIED BY '123456';
确定后提示：error1064<42000>错误错误怎么办啊？谢谢！

Answer 1

GRANT select,insert ON student.* TO YanBob@'192.168.1.11' IDENTIFIED BY '123456';
1、看看去掉insert后面的'，'
2、'192.168.1.11' 两边加上''看看

Answer 2

你都没写'
mysql>GRANT select,insert,ON student.* TO YanBob@'192.168.1.11'