Skip to content

Instantly share code, notes, and snippets.

@evansmwendwa

evansmwendwa/mysql-super-user.md

Created February 29, 2020 14:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save evansmwendwa/495f728012a1b1fa24688097ce2fbf01 to your computer and use it in GitHub Desktop.
Save evansmwendwa/495f728012a1b1fa24688097ce2fbf01 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-super-user.md

Creating a MySql Super user

CREATE USER 'dev'@'localhost' IDENTIFIED BY 'secret';

GRANT ALL PRIVILEGES ON *.* TO 'dev'@'localhost' WITH GRANT OPTION;

CREATE USER 'dev'@'%' IDENTIFIED BY 'secret';

GRANT ALL PRIVILEGES ON *.* TO 'dev'@'%' WITH GRANT OPTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment