Super Useful commands MySQL Shell Terminal

mysql -u root -p
show databases;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE dbname;
USE dbname;
DROP DATABASE dbname;