Always CC the list. You will get better / faster responses.
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] thats is the syntax it tells me to use so i typed CREATE USER dimitri [IDENTIFIED BY [PASSWORD] '******']; were the starts are my password, i hav tried fiddling with the syntax but nothing worked. for the abouve i get this error code, but i dont think the error code will help 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 '[IDENTIFIED BY [PASSWORD] '******']' at line 1
The stuff in []'s means it's optional. If you do create user blah; it will create user blah with no password If you do create user blah identified by 'xxx'; It will create user blah with password 'xxx' -- Postgresql & php tutorials http://www.designmagick.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
