Skip to content

Instantly share code, notes, and snippets.

@MrSnyder

MrSnyder/sql_cheatsheet.md

Last active June 4, 2020 05:39
Show Gist options
  • Save MrSnyder/554892c10be0c6d860ff68124d92f5b3 to your computer and use it in GitHub Desktop.
Save MrSnyder/554892c10be0c6d860ff68124d92f5b3 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Cheatsheet
Raw
sql_cheatsheet.md

SQL Cheatsheet

MySQL

-- start via docker
docker run --name=mystuff-mysql -d -e MYSQL_ROOT_PASSWORD=trallalla -e MYSQL_DATABASE=my_stuff -e MYSQL_USER=my_stuff -e MYSQL_PASSWORD=my_stuff -p 3306:3306 mysql:8

-- create database + user
CREATE DATABASE IF NOT EXISTS my_stuff;
CREATE USER IF NOT EXISTS 'my_stuff'@'%' IDENTIFIED BY 'my_stuff';
GRANT ALL PRIVILEGES ON my_stuff.* TO 'my_stuff'@'%';

-- disable password plugin
uninstall plugin validate_password;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment