Sunday 12 January 2014

MySQL Create Database with UTF8 Character Set

 
CREATE DATABASE `database_name` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON `database_name`.* TO `username`@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
 
Alternate option by using 'CREATE SCHEMA'
 
CREATE SCHEMA `database_name` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON `database_name`.* TO `username`@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES; 

No comments:

Post a Comment