Skip to content

Instantly share code, notes, and snippets.

@nateflink
Last active August 29, 2015 14:04
Show Gist options
  • Save nateflink/946aa10d3872ba896ea9 to your computer and use it in GitHub Desktop.
Save nateflink/946aa10d3872ba896ea9 to your computer and use it in GitHub Desktop.
MYSQL create db
CREATE USER 'foobaz'@'%' IDENTIFIED BY 'foopassword';
CREATE DATABASE IF NOT EXISTS `foobaz` ;
GRANT ALL PRIVILEGES ON foobaz.* TO foobaz@localhost IDENTIFIED BY 'foopassword';
;superuser
CREATE USER 'user'@'%' IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;
CREATE USER 'user'@'localhost' IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment