Error in SQL Query..
Hi,
Im trying to create a user in mysql as root user. Im getting an error as given below. shell> CREATE USER david PASSWORD blue ; 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 david PASSWORD' at line 1 Using mysql-4.1. i checked the manual and found this syntax to be correct. Couldn find the problem? Please someone help me in this.. Thanks Gobi |
You need to read the mysql reference manual:
http://dev.mysql.com/doc/refman/5.0/en/ Quote:
CREATE USER david IDENTIFIED BY 'blue' |
All times are GMT -5. The time now is 02:19 PM. |