Page 1 of 1

Simple Mysql Ask

Posted: Thu Oct 12, 2006 1:21 am
by JosiaMFire22
Ok, I am only asking this as a last resort. Please dont be affended by the simplicity of the question, I have spent to long trying to get it working.
Anyways I want to create a mysql account/login (user=bob pass=bill) then I want to grant all priveliges to this account on a database called "userlist". what should I be typing, this is what i am currently using.

CREATE USER bob IDENTIFIED BY PASSWORD("bill");
GRANT ALL ON userlist.* TO bob IDENTIFIED BY PASSWORD 'bill';

Sorry about this :oops: Im still new to the scene and need to use very little mysql. Note I have consulted the manual??

Posted: Thu Oct 12, 2006 6:33 am
by feyd
What problem are you having with the queries? On first glance, they look about right.

Posted: Thu Oct 12, 2006 10:22 pm
by JosiaMFire22
thanks heaps man the return error I get for the first line is: ERROR 1064 (42000) you have an error in your syntax... .... to use near '('bill')'
come to think of it the second wont work without the first working.