MySQL Forums
Forum List  »  Newbie

can't create a new account
Posted by: homer_3
Date: July 29, 2005 12:21PM

I am trying to create a new account called user but every time I do it I get an error that says incorrect syntax. I have tried:

create on *.* to user@localhost identified by pass;
create on *.* to user@localhost identified by 'pass';
create user user identified by pass;
create user user identified by 'pass';
grant all privilages on *.* to user@localhost identified by pass;
grant all privilages on *.* to user@localhost identified by 'pass';
create user user password pass;
create user user password 'pass';

I have found all these on the web in sql help pages but none work. Can someone tell me how to create a new user account? thanks.

Options: ReplyQuote


Subject
Written By
Posted
can't create a new account
July 29, 2005 12:21PM
July 29, 2005 12:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.