Mysql config on ubunu 12.04

mysql config.txt

sudo apt-get install mysql-server
sudo apt-get install mysql-client

sudo apt-get install libmysqlclient-dev  // for environment development

sudo /etc/init.d/mysql restart

### crear base de datos con root y asignar permisos
mysql -u root -p
Enter password:
create database mybd;
exit

## borrar base de datos
DROP DATABASE mydb;

mysql -u root -p mydb < db-data.sql  ## restore
mysqldump -u root -p mydb > mydbbk-$(date +"%Y-%m-%d.%H:%M:%S").sql   ## backup

mysql -u root -p
Enter password:
grant all privileges on mybd.* to admin@localhost identified by ‘adminbd’;
flush privileges;
exit

mysql -u admin -p mybd

### crear usuario django con password django y asignar permisos
mysql -u root -p
Enter password:

CREATE USER 'django'@'localhost' IDENTIFIED BY 'django';
SELECT user from mysql.user; # checkea usuarios
create database royalpi;
GRANT all privileges on royalpi.* to 'django'@'localhost'; # asigna todos los permisos
GRANT select, insert on royalpi.* to 'django'@'localhost'; # asignas permisos para leer e insertar
FLUSH PRIVILEGES; # refresh all privileges, no mandatory
SHOW grants for django@localhost;

## references
https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql
http://coderz4life.wordpress.com/2012/07/29/mysql-query-browser-in-ubuntu-12-04/