Ubuntu server 12.04/mysql

Ubuntu Server 12.04

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;

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;