Skip to content

Instantly share code, notes, and snippets.

@nuclearglow

nuclearglow/gist:d204c6e22241dc87d8c85f01a833d05e

Last active January 18, 2021 21:35
Show Gist options
  • Save nuclearglow/d204c6e22241dc87d8c85f01a833d05e to your computer and use it in GitHub Desktop.
Save nuclearglow/d204c6e22241dc87d8c85f01a833d05e to your computer and use it in GitHub Desktop.
Download ZIP
MySQL basic admin
Raw
gistfile1.txt
CREATE DATABASE db CHARACTER SET utf8 COLLATE 'utf8_general_ci';
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON db.* TO 'username'@'localhost';
GRANT FILE ON *.* TO 'username'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment