Friday 22 April 2011

Create a MySQL db with UTF8 support



$ mysql -u root -p
mysql> CREATE USER 'micharg'@'%' IDENTIFIED BY 'micharg1234';
mysql> CREATE DATABASE mydb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> GRANT ALL ON mydb.* TO 'micharg'@'localhost' identified by 'micharg1234'; 

No comments:

Post a Comment