MySQL Commands

Here you will find useful mysql commands :

Users

Create user and grant priviliges on to the db :

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';

List all users :

 SELECT User FROM mysql.user; 

Delete user :

drop user username@localhost;

Tables

CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

List all the databases :

show databases; 

Delete a database :

drop database [database name]; 

Other

Connect to the mysql terminal :

sudo mysql -u root -p

Exit : FLUSH PRIVILEGES; and EXIT;