MySQL - some basic command

Create new Database

create database DataBaseName;

Create User

CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';

Grant privileges on Datatabase

GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost'; - limited privileges
or
GRANT ALL ON *.* TO 'user1'@'localhost'; - All privileges
or
GRANT ALL PRIVILEGES ON * . * TO 'sunil'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; - root level privileges

Backup Database
mysqldump -u username -p -h hostname DatabaseName > exportedfilename.sql

Restore Database from dump
mysqldump -u username -p -h hostname DatabaseName < mysqldumpfilename.sql

Find version of mysql

select version();

Change Password for user
update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='user';
mysql> flush privileges;