Description:
When trying to connect to a UTF8 database (innodb v4.1.10-standard-log) which exists on a Latin1 server, I am unable to see the table list for the UTF8 schema but I am able to connect to other databases that are Latin1 with the same account and password. The message "fetching data" remains where the table list would usually display. This is also a problem for Toad for MySQL but is not a problem for the MySQL Control Center 0.9.4-beta. I am able to successfully connect using Putty for command line access.
character_set_client = latin1
character_set_connection = latin1
character_set_database = utf8
character_set_results = latin1
character_set_server = latin1
character_set_system = utf8
collation_connection = latin1_swedish_ci
collation_database = utf8_general_ci
collation_server = latin1_swedish_ci
How to repeat:
Create a Latin1 installation and then create a UTF8 database within the installation.
Try to connect to the new UTF8 database.
Suggested fix:
Allow full access to all databases using the relevant collection/character set for the database.
