Simple Mysql Ask
Posted: Thu Oct 12, 2006 1:21 am
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
Im still new to the scene and need to use very little mysql. Note I have consulted the manual??
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