MARIADB Chinese Characters

Cetos7 under

http://hongjun.blog.51cto.com/445761/400985

1. Copy a file into/etc/my.cnf

cp/usr/share/mysql/my-large.cnf/etc/my.cnf

Then modify the/etc/my.cnf file

Add Default-character-set=utf8 under [client]

Under [mysqld] add Default-character-set=utf8 init_connect= ' Set NAMES UTF8 '

add Default-character-set=utf8 under [MySQL]

Then restart the MySQL server.

Can be an error in the process of restarting

Starting MySQL .......                                            The server quit without updating PID file (/var/lib/mysql/node1.pid). Failed

Check the/var/lib/mysql/node1.error error file to find

101004 20:23:38 [ERROR]/usr/sbin/mysqld:unknown variable ' Default-character-set=utf8 '

This is because MYSQLD cannot recognize this format and can change [mysqld] Default-character-set=utf8 ' to

Character_set_server=utf8

Then reboot is OK!

Under Windows:

Modify File \xampp\mysql\bin\my.ini

Remove comments

Restart Service, ok!

MARIADB Chinese Characters