Skip to content

Instantly share code, notes, and snippets.

@pavgup

pavgup/grant.sql

Last active November 25, 2015 16:29
Show Gist options
  • Save pavgup/462642363460291e12c4 to your computer and use it in GitHub Desktop.
Save pavgup/462642363460291e12c4 to your computer and use it in GitHub Desktop.
Download ZIP
granting everything to root on mariadb over a private subnet
Raw
grant.sql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.31.%.%' IDENTIFIED BY 'APASSWORDTHATISNOTREAL' WITH GRANT OPTION;
UPDATE mysql.user SET password=PASSWORD('realpasswordzl33t') WHERE User="root";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment