铁汁们 我这句语句有错吗，为什么mysql报我语法错误

Question

//这是给权限
grant select on test.emp3 to 'u_wuyanzu' @'localhost' identified by '1234';

//这是报错
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by '1234'' at line 1

Answer 1

identified by '1234'是修改密码的意思，修改：

grant select on test.emp3 to 'u_wuyanzu' @ '%'