Simple Mysql Ask

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
JosiaMFire22
Forum Newbie
Posts: 9
Joined: Thu Oct 12, 2006 1:12 am

Simple Mysql Ask

Post 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??
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

What problem are you having with the queries? On first glance, they look about right.
JosiaMFire22
Forum Newbie
Posts: 9
Joined: Thu Oct 12, 2006 1:12 am

Post 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.
Post Reply