Skip to content

Instantly share code, notes, and snippets.

@fvosberg

fvosberg/create_db.sql

Created August 31, 2015 19:39
Show Gist options
  • Save fvosberg/60ed251033debd0ec770 to your computer and use it in GitHub Desktop.
Save fvosberg/60ed251033debd0ec770 to your computer and use it in GitHub Desktop.
Download ZIP
Create Mysql database with user
Raw
create_db.sql
CREATE DATABASE `databasename` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL 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