MySQL Manual
A Problems and Common Errors
- A.2 Common Errors When Using MySQL
- A.2.1
Access deniedError - A.2.2
MySQL server has gone awayError - A.2.3
Can't connect to [local] MySQL serverError - A.2.4
Client does not support authentication protocolerror - A.2.5
Host '...' is blockedError - A.2.6
Too many connectionsError - A.2.7
Some non-transactional changed tables couldn't be rolled backError - A.2.8
Out of memoryError - A.2.9
Packet too largeError - A.2.10 Communication Errors / Aborted Connection
- A.2.11
The table is fullError - A.2.12
Can't create/write to fileError - A.2.13
Commands out of syncError in Client - A.2.14
Ignoring userError - A.2.15
Table 'xxx' doesn't existError - A.2.16
Can't initialize character set xxxerror - A.2.17 File Not Found
- A.2.1
A.2.16 Can't initialize character set xxx error
If you get an error like:
MySQL Connection Failed: Can't initialize character set xxx
This means one of the following things:
-
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 with
--with-charset=xxxor with--with-extra-charsets=xxx. See section 2.3.3 TypicalconfigureOptions. All standard MySQL binaries are compiled with--with-extra-character-sets=complexwhich will enable support for all multi-byte character sets. See section 4.6.1 The Character Set Used for Data and Sorting. -
The character set is a simple character set which is not compiled into
mysqldand the character set definition files are not in the place where the client expects to find them. In this case you need to:-
Recompile the client with support for the character set.
See section 2.3.3 Typical
configureOptions. -
Specify to the client where the character set definition files are. For many
clients you can do this with the
--character-sets-dir=path-to-charset-diroption. - Copy the character definition files to the path where the client expects them to be.
-
Recompile the client with support for the character set.
See section 2.3.3 Typical
