Skip to content

Instantly share code, notes, and snippets.

@bjdixon
Last active August 29, 2015 14:01
Show Gist options
  • Save bjdixon/ed62f10e80e8b3319ca1 to your computer and use it in GitHub Desktop.
Save bjdixon/ed62f10e80e8b3319ca1 to your computer and use it in GitHub Desktop.
create mysql database with owner for django
$ mysql -h host -u user -p
mysql> CREATE DATABASE dbname;
mysql> USE dbname
mysql> GRANT USAGE ON *.* TO dbuser@localhost IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@'localhost';
mysql> quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment