Thursday, 17 March 2011

create user & grant priveleges

had privilege problems. remembered that i hadnt created user/granted priveleges


CREATE USER 'siobhan'@'localhost' IDENTIFIED BY 'password1';

CREATE USER 'jimi'@'localhost' IDENTIFIED BY 'password2';

GRANT ALL PRIVILEGES ON login_membership TO 'siobhan'@'localhost';

GRANT ALL PRIVILEGES ON login_membership TO 'jimi'@'localhost';

No comments:

Post a Comment