I’ve been having a problem starting the MySQL GUI Tools: Query Browser and Administrator with Arch Linux. I am using libxml2-2.7.6-1, zlib-1.2.3.4-4 and mysql–gui-tools-5.0r14-4. They all seem to be installed properly.
Whenever I start them I get this error:
/usr/bin/mysql-query-browser-bin: symbol lookup error: /usr/lib/libxml2.so.2: undefined symbol: gzopen64
After a ton of searching online with no success I came upon this post. It basically says that in the /usr/lib directory is a problematic libz.so.1. In my case I have a symbolic link to libz.so.1.2.3.4. It seemed correct to me, but I deleted the sym link and remade it. That fixed the problem and mysql query browser works again from the CLI. It doesn’t work from the start menu.
I have to do this everytime I start mysql-query-browser. Not sure why and it’s annoying, but it’s a workaround.