Bug #17271 mysql client tool could not find ../share/charsets folder and fails.
Submitted: 9 Feb 2006 10:04 Modified: 9 Feb 2006 10:08
Reporter: Mr. Sea Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.18 OS:Windows (Windows 2000 Pro. SP4)
Assigned to: CPU Architecture:Any

[9 Feb 2006 10:04] Mr. Sea
Description:
I setup MySQL 5.0.18 on a Windows 2000 SP4 machine.
I used "mysql-essential-5.0.18-win32.msi" installer package for installation. I configured character set to latin5 (with MySQL Server Instance Config Wizard). Server started without any problem but when I try to use "mysql" command line tool I saw following error message and mysql client could not start;

mysql: Character set 'latin5' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file

After this error I add following line(character-sets-dir) into my.ini file and now it is working.

# CLIENT SECTION
...
[mysql]
default-character-set=latin5
character-sets-dir="C:/Program Files/MySQL/MySQL Server 5.0/share/charsets"

I think this is a bug of "MySQL Server Instance Config Wizard" tool.

Mr.Sea
mrsea77@yahoo.com

How to repeat:
Install mysql server and set character set to latin5 during config wizard. After installation try to use mysql tool with this command;

C:\>mysql -u root -p
mysql: Character set 'latin5' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file

Suggested fix:
After this error I add following line (character-sets-dir) into my.ini file and now it is working.

# CLIENT SECTION
...
[mysql]
default-character-set=latin5
character-sets-dir="C:/Program Files/MySQL/MySQL Server 5.0/share/charsets"
[9 Feb 2006 10:08] Andrey Hristov
bug #17270