[nicpon]

Hey,
i`m trying to add user in mysql with statement i got from www.mysql.com
" CREATE USER 'ian'@'localhost' IDENTIFIED BY 'asdasd';" and i get sysntax error.
Does anyone know why is that ?? Mysql ver 4.1.13. Also I downloaded the mysql-administrator for linux and when i try to add user there i get an error saying duplicate username and i cant add any user there too. I`m running RH enterprise 4.0 and i have only root in mysql.

[UnrealEd]

shouldn't it be:
" CREATE USER 'ian'@'localhost' IDENTIFIED BY 'asdasd' ";

maybe you just mistyped

Hope it works,

UnrealEd

[nicpon]

This is exactly what i type:
CREATE USER 'ian'@'localhost' IDENTIFIED BY 'asdasd';