Mysql
From Attie's Wiki
(Difference between revisions)
m |
m (→Useful commands) |
||
| Line 9: | Line 9: | ||
== Useful commands == | == Useful commands == | ||
| + | <source lang="mysql"> | ||
| + | show databases; | ||
| + | </source> | ||
<source lang="mysql"> | <source lang="mysql"> | ||
Latest revision as of 11:39, 3 February 2015
mysql --user=$USERNAME -p # backup mysqldump --user=$USERNAME -p $DATABASE > $SQLFILE # restore mysql --user=$USERNAME -p $DATABASE < $SQLFILE
[edit] Useful commands
SHOW DATABASES;
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;
