Skip to content

Instantly share code, notes, and snippets.

@lpirir

lpirir/Create UTF8 Database

Created December 29, 2014 01:34
Show Gist options
  • Save lpirir/4fe348fafb49162a8ddb to your computer and use it in GitHub Desktop.
Save lpirir/4fe348fafb49162a8ddb to your computer and use it in GitHub Desktop.
Download ZIP
Create a UTF8 database in MySQL
Raw
Create UTF8 Database
CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON `mydb`.* TO `username`@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment