# connect to mysql using the root user

mysql -u root -p

# create new user 'dbuser' with password 'cs4640'

CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'cs4640';

# give lots of privileges to dbuser

GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'localhost';

# Reload the MySQL privileges

FLUSH PRIVILEGES;

# quit out of MySQL

quit;

# connect with our new user

mysql -u dbuser -p

# see all databases in MySQL

SHOW DATABASES;

# create a new database

CREATE DATABASE class_examples;

# change into that database

USE class_examples;

# create the users table

CREATE TABLE users(
    email VARCHAR(40),
    password CHAR(40) NOT NULL,
    first VARCHAR(40) NOT NULL,
    last VARCHAR(40) NOT NULL,
    reg_date DATETIME NOT NULL,
    PRIMARY KEY (email)
) ENGINGE = InnoDB;

# show the columns in a table

DESCRIBE users;