Mysql
From Attie's Wiki
(Difference between revisions)
m (Created page with '<source lang="bash"> mysql --user=$USERNAME --password=$PASSWORD </source> == Useful commands == <source lang="mysql"> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; <…') |
Revision as of 17:04, 24 January 2012
mysql --user=$USERNAME --password=$PASSWORD
Useful commands
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE database;
GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' WITH GRANT OPTION;