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'; <…') |
m |
||
| Line 14: | Line 14: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' WITH GRANT OPTION; | GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' WITH GRANT OPTION; | ||
| + | </source> | ||
| + | |||
| + | <source lang="mysql"> | ||
| + | REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'localhost'; | ||
| + | </source> | ||
| + | |||
| + | <source lang="mysql"> | ||
| + | DROP DATABASE db; | ||
| + | </source> | ||
| + | |||
| + | <source lang="mysql"> | ||
| + | DROP USER user; | ||
</source> | </source> | ||
Revision as of 17:06, 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;
REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'localhost';
DROP DATABASE db;DROP USER user;
