MySQL cheatsheet: create a database and assign permissions to users

create_database.sql

-- Create the database
CREATE DATABASE University;

-- Use a database
USE University;

-- Assign permissions to a database
GRANT ALL ON University TO mike
GRANT INSERT, UPDATE ON University.Students TO william
GRANT SELECT(id, name) ON University.Teachers TO john 

-- Remove a database
DROP DATABASE University;