MySQL Quick References
These are some quick references of SQL and CLI commands used commonly.
Create
Create Database
create database [databasename];
Create User with Databse
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE dbname;
GRANT ALL PRIVILEGES ON dbname.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
Use Database
use [db name];
List
List Databases
show databases;
List Users
SELECT User, Host FROM mysql.user;
List Tables
show tables;
Describe Table
describe [table name];
Drop
Drop Database
drop database [database name];
Drop table
drop table [table name];