Mysql
From Attie's Wiki
(Difference between revisions)
m |
m |
||
| 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> | ||
Revision as of 17:10, 25 January 2012
mysql --user=$USERNAME -p # backup mysqldump --user=$USERNAME -p $DATABASE > $SQLFILE # restore mysql --user=$USERNAME -p $DATABASE < $SQLFILE
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;
