MySQL command line cheatsheet

/* import database dump */

mysql -u username -p dbname < dump.sql

/* export database dump */

mysqldump -u username -p dbname > dump.sql

/* scp download dump */

scp -P port -i /home/user/key root@IP:/home/website/dump.sql /home/user/dir1

/* create new database */

CREATE DATABASE database_name;
SHOW DATABASES;
USE database_name;

/* create new user */

create user 'dbuser'@'localhost' identified by 'pass';
GRANT ALL PRIVILEGES ON `databasename`.* TO 'dbuser'@'localhost';
FLUSH PRIVELEGES;