Skip to content

Instantly share code, notes, and snippets.

@thiamteck

thiamteck/mysql_old_school_user_creation.sql

Created November 16, 2019 15:49
Show Gist options
  • Save thiamteck/235bac60f00704d967c1b2e12c3c1072 to your computer and use it in GitHub Desktop.
Save thiamteck/235bac60f00704d967c1b2e12c3c1072 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_old_school_user_creation.sql
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment