Skip to content

Instantly share code, notes, and snippets.

@Ulv

Ulv/mysql_createdb.sql

Last active January 10, 2017 12:16
Show Gist options
  • Save Ulv/c3fc1f99fd875f6e07645b381fb892ea to your computer and use it in GitHub Desktop.
Save Ulv/c3fc1f99fd875f6e07645b381fb892ea to your computer and use it in GitHub Desktop.
Download ZIP
Creates mysql database and user with permissions
Raw
mysql_createdb.sql
CREATE DATABASE IF NOT EXISTS dbname;
GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@'localhost' IDENTIFIED BY 'dbpassword';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment