MySQL error problem resolution character set ' UTF8MB4 ' is not a compiled character set

Mysql:character set ' Utf8mb4 ' is not a compiled Character set and was not specified in the '/usr/share/mysql/charsets/inde X.xml ' File

Solution to the error

1, because the daily program uses the character set UTF8MB4, in order to avoid each update, set names UTF8MB4, the configuration file changed, as follows:

Added default character set for MySQL client

[[Email protected]~]# vim/etc/my.cnf

#my. cnf

[Client]

Port = 3306

Socket =/home/mysql/mysql.sock

Default-character-set=utf8mb4

2. Restart MySQL Service

[[Email protected]~]# service MySQL Restart

Shutting down MySQL (Percona Server) .... success!

Starting MySQL (Percona Server) .... success!

3, when entering MySQL, error:

[Email protected]~]# MySQL

Logging to file '/home/mysql/query.log '

Mysql:character set ' Utf8mb4 ' is not a compiled Character set and was not specified in the '/usr/share/mysql/charsets/inde X.xml ' File

4, Baidu has a solution:

[[Email protected]~]# vim/etc/my.cnf

#my. cnf

[Client]

Port = 3306

Socket =/home/mysql/mysql.sock

Character-sets-dir=/usr/local/percona-server-5.5.20-rel24.1-217.linux.x86_64/share/charsets

Default-character-set=utf8mb4

5, after restarting MySQL, still reported the same mistake

[[Email protected]~]# service MySQL Restart

Shutting down MySQL (Percona Server) .... success!

Starting MySQL (Percona Server) .... success!

[Email protected]~]# MySQL

Logging to file '/home/mysql/query.log '

Mysql:character set ' Utf8mb4 ' is not a compiled Character set and was not specified in the '/usr/share/mysql/charsets/inde X.xml ' File

6. The/usr/bin is called by the MySQL command.

[[email protected] ~]# ls/usr/bin/|grep MySQL

Msql2mysql

Mysql

Mysqlaccess

Mysqladmin

Mysqlbinlog

Mysqlcheck

Mysql_config

Mysqld_multi

Mysqld_safe

Mysqldump

Mysql_find_rows

Mysqlimport

Mysqlshow

Mysqlslap

Mysql_waitpid

7. Found on this server before I install mysql5.5.20, installed mysql5.1 client

[[email protected] ~]# rpm-qa |grep MySQL

Mysql-5.1.73-3.el6_5.x86_64

Mysql-libs-5.1.73-3.el6_5.x86_64

8. Copy all MySQL commands under mysql5.5.20 to the/usr/bin directory

\cp/usr/local/percona-server-5.5.20-rel24.1-217.linux.x86_64/bin/*/usr/bin/

9, 5.5.20 compared to the 5.1 version added a lot of commands

[[Email protected]~]# ls/usr/bin/|grep MySQL

Msql2mysql

Mysql

Mysqlaccess

Mysqlaccess.conf

Mysqladmin

Mysqlbinlog

Mysqlbug

Mysqlcheck

Mysql_client_test

Mysql_config

Mysql_convert_table_format

Mysqld

Mysqld_multi

Mysqld_safe

Mysqldump

Mysqldumpslow

Mysql_find_rows

Mysql_fix_extensions

Mysqlhotcopy

Mysqlimport

mysql_install_db

Mysql_plugin

Mysql_secure_installation

Mysql_setpermission

Mysqlshow

Mysqlslap

Mysqltest

Mysql_tzinfo_to_sql

Mysql_upgrade

Mysql_waitpid

Mysql_zap

10, after the modification, re-use into the mysql,ok~

This article is from the "rookie site" blog, please be sure to keep this source http://yangjingangel.blog.51cto.com/8351501/1754413

MySQL error problem resolution character set ' UTF8MB4 ' is not a compiled character set