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 (→Useful commands) |
||
(4 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
<source lang="bash"> | <source lang="bash"> | ||
− | mysql --user=$USERNAME -- | + | mysql --user=$USERNAME -p |
+ | |||
+ | # backup | ||
+ | mysqldump --user=$USERNAME -p $DATABASE > $SQLFILE | ||
+ | # restore | ||
+ | mysql --user=$USERNAME -p $DATABASE < $SQLFILE | ||
</source> | </source> | ||
== Useful commands == | == Useful commands == | ||
+ | <source lang="mysql"> | ||
+ | show databases; | ||
+ | </source> | ||
+ | |||
<source lang="mysql"> | <source lang="mysql"> | ||
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; | CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; | ||
Line 14: | Line 23: | ||
<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> |
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;