Mysql
From Attie's Wiki
(Difference between revisions)
m |
m (→Useful commands) |
||
| Line 4: | Line 4: | ||
== Useful commands == | == Useful commands == | ||
| + | <source lang="bash"> | ||
| + | mysql --user=user -p | ||
| + | </source> | ||
| + | |||
<source lang="mysql"> | <source lang="mysql"> | ||
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; | CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; | ||
| Line 26: | Line 30: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
DROP USER user; | DROP USER user; | ||
| + | </source> | ||
| + | |||
| + | == Import a *.sql backup == | ||
| + | <source lang="bash"> | ||
| + | mysqlimport --user=user -p -D wiki_old mediawiki.sql | ||
</source> | </source> | ||
Revision as of 17:03, 25 January 2012
mysql --user=$USERNAME --password=$PASSWORD
Useful commands
mysql --user=user -p
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;Import a *.sql backup
mysqlimport --user=user -p -D wiki_old mediawiki.sql
