Mysql

From XPUB & Lens-Based wiki

Create a database + user for a project

sudo su
mysql -u root
create database FOO;
grant all on FOO.* to FOOUSER@'localhost' identified by 'FOOPASS';

NB: localhost means *really* localhost -- it means that only logins are allowed from the same machine and is a *good idea* for most uses. This creates a database named FOO with user FOOUSER and password FOOPASS;

Create user

CREATE USER 'USERNAME'@'localhost' IDENTIFIED BY 'PASSWORD';


To dump the database

mysqldump -u FOOUSER  FOO > foodump.sql
gzip foodump.sql