Skip to content

Instantly share code, notes, and snippets.

@grzegorzblaszczyk

grzegorzblaszczyk/create_database_utf_collation.sql

Last active August 29, 2015 14:04
Show Gist options
  • Save grzegorzblaszczyk/52fa65a400cef8dd36bf to your computer and use it in GitHub Desktop.
Save grzegorzblaszczyk/52fa65a400cef8dd36bf to your computer and use it in GitHub Desktop.
Download ZIP
Create database with UTF-8 collation
Raw
create_database_utf_collation.sql
CREATE DATABASE [database] DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE USER [user] IDENTIFIED BY '[pass]';
CREATE USER [user]@'localhost' IDENTIFIED BY '[pass]';
GRANT ALL PRIVILEGES ON [database].* TO [user];
GRANT ALL PRIVILEGES ON [database].* TO '[user]'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment