6
Jul

1.Login msyql command mode and query mysql check character below

mysql> show variables like "%character%";show variables like "%collation%";

2.edit my.cnf

[mysql]
default-character-set=utf8

[mysqld]
collation_server=utf8_general_ci
character_set_server=utf8

3. check charset mysql again

Short link: http://taxze.com/?p=102
Canonical link: http://www.taxze.com/change-charset-in-mysql-5-5-with-my-cnf/


how to change charset mysql directadmin, mysql "change charset", pasword andusername, debian mysql 5.5 character-set my.cnf,

Leave a Reply “Change charset in MySQL 5.5 with my.cnf”