Skip to content

Instantly share code, notes, and snippets.

@mtrl
Created August 19, 2011 16:05
Show Gist options
  • Save mtrl/1157193 to your computer and use it in GitHub Desktop.
Save mtrl/1157193 to your computer and use it in GitHub Desktop.
Create mysql user via command
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment