Ubuntu server 12.04/mysql
From Attie's Wiki
(Difference between revisions)
m (→Useful commands) |
m (→Useful commands) |
||
Line 25: | Line 25: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
CREATE DATABASE database; | CREATE DATABASE database; | ||
+ | </source> | ||
+ | |||
+ | <source lang="mysql"> | ||
+ | SHOW DATABASES; | ||
</source> | </source> | ||
Latest revision as of 11:42, 7 May 2012
apt-get install mysql-server php5-mysql
[edit] Configuring a MySQL Server
... not much to do really
[edit] Backup and Restore
# get a shell mysql --user=$USERNAME -p # backup mysqldump --user=$USERNAME -p $DATABASE > $SQLFILE # restore mysql --user=$USERNAME -p $DATABASE < $SQLFILE
[edit] Useful commands
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE database;
SHOW DATABASES;
GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' WITH GRANT OPTION;
SHOW GRANTS FOR 'user'@'localhost';
REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'localhost';
DROP DATABASE db;
DROP USER user;