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];