Skip to content

Instantly share code, notes, and snippets.

@Mao8a

Mao8a/mysql--create-user-and-grant-privileges.md

Created July 18, 2015 02:04
Show Gist options
  • Save Mao8a/aedc8659981adfa73c21 to your computer and use it in GitHub Desktop.
Save Mao8a/aedc8659981adfa73c21 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL: Create User & Grant privileges
Raw
mysql--create-user-and-grant-privileges.md

Create user and grant privileges

CREATE USER '[username]'@'%' IDENTIFIED BY '[password]';
GRANT ALL ON [database].* TO '[username]'@'%';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment