MySQL Bugs: #12624: user create

Bug #12624	user create
Submitted:	17 Aug 2005 14:48	Modified:	17 Aug 2005 14:55
Reporter:	Rajeshkumar Nagarajan	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:		OS:	Windows (windows xp)
Assigned to:		CPU Architecture:	Any

Description:
mysql> CREATE USER 'joey'@'%' IDENTIFIED BY 'joey123';
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 'USER
'joey'@'%' IDENTIFIED BY 'joey123'' at line 1

i have MySQL server version is MySQL Server 4.1.so how is query plz

How to repeat:
mysql> CREATE USER 'joey'@'%' IDENTIFIED BY 'joey123';
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 'USER
'joey'@'%' IDENTIFIED BY 'joey123'' at line 1

i have MySQL server version is MySQL Server 4.1.so how is query plz

Suggested fix:
mysql> CREATE USER 'joey'@'%' IDENTIFIED BY 'joey123';
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 'USER
'joey'@'%' IDENTIFIED BY 'joey123'' at line 1

i have MySQL server version is MySQL Server 4.1.so how is query plz

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

The documentation (http://dev.mysql.com/doc/mysql/en/create-user.html) reads:
"The CREATE USER statement was added in MySQL 5.0.2."