Solution for Unknown OS character set 'ISO-8859-15'

[Net Vicious]

If you get this error:

/usr/bin/mysql: Switching to the default character set 'latin1'.
/usr/bin/mysql: Unknown OS character set 'ISO-8859-15'.

Surely you should have on the locales something like:

# locale
LANG=es_ES@euro
LC_ALL=es_ES@euro

The problem here it's the @euro part, because it's an alias of ISO-8859-15. MySQL doesn't knows it and shows the error.

One solution should be changing the locales of the entire system to utf8 (in my case es_ES@utf8) or ISO-8859-1 (in my case es_ES@ISO-8859-1), check also de locales.alias file because you should have on it the ISO-8859-15 problem there.

Other solution could be editing the startup script of mysqld (/etc/init.d/mysql or /etc/rcX.d/mysql) writing on the top of the script this:

export LANG=es_ES.ISO-8859-1
export LC_ALL=es_ES.ISO-8859-1

Change the es_ES with your desired language.

With this we will only change the locales for the mysql process and we won't see the ugly error lines in our logs/mails, ....

Regards,