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

//这是给权限
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

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

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

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632