Skip to content

Instantly share code, notes, and snippets.

@aurels

aurels/gist:186728

Created September 14, 2009 15:37
Show Gist options
  • Save aurels/186728 to your computer and use it in GitHub Desktop.
Save aurels/186728 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sh
# Create a mysql user and give him all rights on a given database
$ mysql -u root -p
GRANT SELECT, LOCK TABLES, INDEX, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP ON specific_database.* TO 'brand_new_user'@localhost IDENTIFIED BY 'awsome_password';
FLUSH PRIVILEGES;
# To improve
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment