# MySQL Quick References

These are some quick references of SQL and CLI commands used commonly.

## Create

### Create Database

```sql
create database [databasename];
```

### Create User with Databse

```sql
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE dbname;
GRANT ALL PRIVILEGES ON dbname.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
```

### Use Database

```sql
use [db name];
```

## List

### List Databases

```sql
show databases;
```

### List Users

```sql
SELECT User, Host FROM mysql.user;
```

### List Tables

```sql
show tables;
```

### Describe Table

```sql
describe [table name];
```

## Drop

### Drop Database

```sql
drop database [database name];
```

### Drop table

```sql
drop table [table name];
```