Ubuntu server 12.04/mysql
From Attie's Wiki
(Difference between revisions)
m |
m |
||
| Line 4: | Line 4: | ||
==Configuring a MySQL Server== | ==Configuring a MySQL Server== | ||
| + | ... not much to do really | ||
| + | |||
| + | ==Backup and Restore== | ||
| + | <source lang="bash"> | ||
| + | # get a shell | ||
| + | mysql --user=$USERNAME -p | ||
| + | |||
| + | # backup | ||
| + | mysqldump --user=$USERNAME -p $DATABASE > $SQLFILE | ||
| + | # restore | ||
| + | mysql --user=$USERNAME -p $DATABASE < $SQLFILE | ||
| + | </source> | ||
| + | |||
| + | == Useful commands == | ||
| + | <source lang="mysql"> | ||
| + | CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; | ||
| + | </source> | ||
| + | |||
| + | <source lang="mysql"> | ||
| + | CREATE DATABASE database; | ||
| + | </source> | ||
| + | |||
| + | <source lang="mysql"> | ||
| + | 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> | ||
Revision as of 22:49, 2 May 2012
apt-get install mysql-server php5-mysql
Configuring a MySQL Server
... not much to do really
Backup and Restore
# get a shell 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;
