Skip to content

Instantly share code, notes, and snippets.

@nocash

nocash/create_user.sql

Created January 20, 2011 16:00
Show Gist options
  • Save nocash/788097 to your computer and use it in GitHub Desktop.
Save nocash/788097 to your computer and use it in GitHub Desktop.
Download ZIP
mysql create user syntax that I can never remember.
Raw
create_user.sql
CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;
CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment