Monthly Archives: May 2013

Mysql create user + password

CREATE USER 'myuser'@'localhost' IDENTIFIED BY '1ed0d4f451266a8e07f3c0c3b54a8c1b';
GRANT ALL ON mydb.* TO 'myuser'@'localhost';

To remove

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'myuser'@'localhost';
DROP USER 'myuser'@'localhost';