Creating a new databsae user

[edwardp]

I am running mySQL 4.1.7-nt on XP.

I am connecting (on cmd line) to mySQL thus:

c:\mysql\bin>mysql -u root -p
ENTER PASSWORD: **********

i then try and do:

mysql>CREATE USER 'abcde'@'localhost' IDENTIFIED BY '12345';

and receive this message:

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 'abcde'@'localhost' IDENTIFIED BY '12345'' at line 1

can anyone see/know why???

[devinemke]

from the manual (http://dev.mysql.com/doc/mysql/en/create-user.html)

The CREATE USER statement was added in MySQL 5.0.2

[edwardp]

so how do i do it in 4.1.7??? is there a past manual??

[Drakla]

Look for 'mysql grant syntax' in goooogle