16 July 2013

CREATE and GRANT MySQL with Super Power

CREATE a new MySQL user...
CREATE USER 'superman'@'localhost' IDENTIFIED BY 'password';
... and GRANT it super power.
GRANT ALL PRIVILEGES ON * . * TO 'superman'@'localhost' WITH GRANT OPTION;