MySQL Cheatsheet

cheats.sql

-- Create a new database
CREATE DATABASE database_name;

-- Create a new user
CREATE USER 'username'@'%' IDENTIFIED BY 'password';

-- Allow user connections to server
GRANT USAGE ON *.* TO 'username'@'%';

-- Grant user privileges on database
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `database_name`.* TO 'username'@'%';

-- Flush privileges
FLUSH PRIVILEGES;