无法创建用户,提示语法错误
我用的是mysql5.0.0-alpha-nt创建了一个会员数据库members
用root身份创建新用户,命令如下:
grant all
on members.*
to double identified by 'double123'
with grant option;
提示错误如下:
ERROR 1064(42000):You have an error in your SQL syntax.Check the mamual that corresponds to your MySQl server version for the right syntax to use near 'double identified by "double123" with grant option'at line 3。
请问如何解决这个问题。。。。。