Skip to content

Instantly share code, notes, and snippets.

@mtrl

mtrl/Create mysql user via command

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.
Download ZIP
Create mysql user via command
Raw
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';
Raw
Createmysqluserviacommand
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