phpMyAdmin gotcha

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Posting this for posterity and for googlers looking for solutions to this

I upgraded PHP on my Fedora Linux server to 4.3.10 due to the recent
security issue and phpMyAdmin stopped working. I realized after lots of
debugging that I'd previously custom-compiled PHP to match my custom
upgrade of MySQL to 4.1.7 from Fedora's development branch. When I let yum
install the pre-built update binary, it had the old MySQL libraries so it
couldn't talk to the newer MySQL with the different character set support.

I finally figured it out when I tried to connect to the DB from another
host running a v3 MySQL and got this error:

mysql: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
mysql: Character set '#33' is not a compiled character set and is not
specified in the '/usr/share/mysql/charsets/Index' file

Site Timeline