Skip to content

Instantly share code, notes, and snippets.

@maxmalakhov

maxmalakhov/DatabaseAndUserCreation.sql

Last active December 19, 2015 12:49
Show Gist options
  • Save maxmalakhov/5958071 to your computer and use it in GitHub Desktop.
Save maxmalakhov/5958071 to your computer and use it in GitHub Desktop.
Download ZIP
Create db and user
Raw
DatabaseAndUserCreation.sql
CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'dbuser'@'%' IDENTIFIED BY 'dbuser';
GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@'%' WITH GRANT OPTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment