Okay, I am trying to get MySQL Administrator and MySQL Query Browser running on my newly installed SUSE 10.1. I am having serious trouble, though.

I downloaded the standard RPM package from dev.mysql.com. When I tried to install it, I get "Failed dependencies: libexpat.so.0 is needed by mysql-query-browser-1.1.18-1.i386"

I checked, this is what I have:
/usr/lib/libexpat.a
/usr/lib/libexpat.la
/usr/lib/libexpat.so
/usr/lib/libexpat.so.1
/usr/lib/libexpat.so.1.5.0

So, I downloaded the statically linked version, untarred it to a folder and tried to run it. It told me it couldn't find libexpat.so.0.

So, I created a symlink called "libexpat.so.0" that pointed to libexpat.so.1.5.0, and tried running it again. It fails with "mysql-query-browser: line 20: 10848 Segmentation fault $PRG-bin".

So, I went back to the site, and downloaded the source. The configure script says I don't have the expat sources. I don't see a expat-devel on the CDs, so now I'm stuck.

MySQL Administrator installs (via generic RPM) and starts up, but it can't connect to any server. It just sits there and "thinks" about connecting forever ("connecting...").

I really need these apps. What can I do?

about mysql administrator. can you start the mysqld manually? try logging on as root and configuring the databases using:

/usr/bin/mysql_install_db --user=mysql

and then starting the server using:

/usr/bin/mysqld_safe --user=mysql &

then you can log on in a second shell window using:

mysql

let me know if this works.

about expat. looks like you're going to have to use google to find expat-devel

yours

hold

The MySQL server daemon runs on another machine. I'm trying to install the Query Browser on a workstation, and the MySQL server daemon runs on a Linux server on the same subnet. I can administer it over SSH using the server's local MySQL client.

I do have the local MySQL client (command line) installed. I don't seem to be able to connect to the server with it, but I'm sure syntax is partly to blame - it thinks I want to connect to the local mysqld process.

Okay...

I installed expat (compiled from source) and copied the source into /usr/include (/usr/include/expat).

I ran the mysql-query-browser configure script, and it failed miserably. Now it complains about verison mis-matches between gtkmm, libkhtml and a handful of other libraries which are gnome related. They claim my libraries are too old and that it cannot compile without it.

SUSE 10.1's libraries might not be bleeding edge, but they're pretty recent. I can see one being out of date, but all of these? It makes me wonder if the source code is at fault. Maybe not, I don't know.

I tried to symlink libexpat.so.0 to point to the new expat I'd compiled (which naturally landed in /usr/local/lib) and tried running the statically compiled version... failed with same results as before (segmentation fault). Without the symlink, the browser "cannot find libexpat.so.0".

I even tried installing klik and tried running it that way. Nope, crashed...

I'm lost. Did I miss something? Is there anything else I can try?