You might see an error like this if you have character set problems:
MySQL Connection Failed: Can't initialize character set charset_name
This error can have any of the following causes:
The character set is a multi-byte character set and you
have no support for the character set in the client. In
this case, you need to recompile the client by running
configure with the
--with-charset=
or
charset_name--with-extra-charsets=
option. See ι
2.9.2. γε
Έεηγͺ configure γͺγγ·γ§γ³γ.
charset_name
All standard MySQL binaries are compiled with
--with-extra-character-sets=complex,
which enables support for all multi-byte character sets.
See ι
4.10.1. γγγΌγΏγγγ³γ½γΌγη¨γγ£γ©γ―γΏ γ»γγγ.
The character set is a simple character set that is not compiled into mysqld, and the character set definition files are not in the place where the client expects to find them.
In this case, you need to use one of the following methods to solve the problem:
Recompile the client with support for the character set. See ι 2.9.2. γε Έεηγͺ configure γͺγγ·γ§γ³γ.
Specify to the client the directory where the
character set definition files are located. For many
clients, you can do this with the
--character-sets-dir option.
Copy the character definition files to the path where the client expects them to be.