3
Aug

How To: Install MySQL Query Browser in Fedora 13 (mysql-gui-tools)

As of Fedora 13, the package mysql-gui-tools is no longer available (replaced by mysql-workbench; see this page), so we’ll have to do things the hard way by digging into the archives over at http://dev.mysql.com. It’s not all that tough, but there are some issues currently (see end of post). I would like to ask others to provide any insight to the issues. So, for now, I present the beginnings of how to install MySQL Query Browser on Fedora 13…

Open the terminal, login as root with ‘su’, and copy/paste the following commands:

<br />
wget http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r12-linux-i386.tar.gz/from/http://mysql.he.net/<br />
tar xzvf mysql-gui-tools-5.0r12-linux-i386.tar.gz -C /opt<br />
cp /opt/mysql-gui-tools-5.0/MySQLQueryBrowser.desktop /usr/share/applications/<br />

A menu link to the program should be available under “Applications -> Programming -> MySQL Query Browser“, however if you want to run it from the terminal, use the following commands:

<br />
PATH=$PATH:/opt/mysql-gui-tools-5.0/<br />
mysql-gui-tools<br />

Now, if your luck is anything like mine, you’ll notice that if you run the program from the command line, you’ll get the initial setup window (strange looking, like theme isn’t being used), then an error message, then nothing happens after filling out the setup information. The error message will probably look something like:

<br />
[[email protected] ~]# /opt/mysql-gui-tools-5.0/mysql-query-browser<br />
/usr/share/themes/Clearlooks/gtk-2.0/gtkrc:55: error: unexpected character `@', expected string constant<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/65-fonts-persian.conf&quot;, line 190: invalid match target &quot;scan&quot;<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/65-fonts-persian.conf&quot;, line 199: invalid match target &quot;scan&quot;<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/65-fonts-persian.conf&quot;, line 208: invalid match target &quot;scan&quot;<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/65-fonts-persian.conf&quot;, line 217: invalid match target &quot;scan&quot;<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/65-fonts-persian.conf&quot;, line 226: invalid match target &quot;scan&quot;<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/65-fonts-persian.conf&quot;, line 235: invalid match target &quot;scan&quot;<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/65-fonts-persian.conf&quot;, line 244: invalid match target &quot;scan&quot;<br />
Fontconfig warning: &quot;/etc/fonts/conf.d/80-delicious.conf&quot;, line 17: invalid match target &quot;scan&quot;<br />
Fontconfig warning: line 73: unknown element &quot;cachedir&quot;<br />
Fontconfig warning: line 74: unknown element &quot;cachedir&quot;<br />

This is actually where I need your help. Does anybody have any ideas? My thought is that symbolic colors were introduced in GTK+2.10 and the mysql-query-browser doesn’t expect symbolic colors, so it throws an error message and messes everything up. However, I wonder if it doesn’t matter since it’s only the appearance of the window. This shouldn’t cause the program to stop working. Maybe it has something to do with the font warnings? But wait, when have warnings ever stopped a program from running?

Anyways, if anybody out there can offer some advice, it would be much appreciated by myself and readers (I’m sure).  If it’s just not going to be possible, I’ll remove this post from the blog to avoid confusion (I’m sure it’s already caused quite a bit).

Source: http://dev.mysql.com/doc/query-browser/en/install-generic-tarball.html
Full list of downloads/mirrors: http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r12-linux-i386.tar.gz/from/pick#mirrors
Note: If ‘wget’ is not available on your system, install it with ‘yum install -y wget’ or use ‘curl url -o filename’ instead.

Feel free to donate if this post prevented any headaches! Another way to show your appreciation is to take a gander at these relative ads that you may be interested in:


There's 2 Comments So Far

  • MySQL Workbench
    August 3rd, 2010 at 11:30 am

    Hi Derek,

    MySQL Administrator and MySQL Query Browser are EOL. They have been replaced by MySQL Workbench, which is available on Win, MacOS, Ubuntu, Suse, Fedora.

    WB 5.2 includes:
    – Model (replacing DBDesigner)
    – Query (replacing MySQL Query Browser)
    – Admin (replacing MySQL Administrator)
    – SSH-Tunnel (for Remote Admin)

    Learn more:
    http://forums.mysql.com/index.php?151

    We would be happy to help you with any issues on Fedora.

    – MySQL Workbench

  • denis
    December 26th, 2013 at 2:20 am

    Not so far I have found new cool tool to work with mySQL on linux – Valentina Studio. Its free edition can do things more than many commercial tools!!
    I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview

Share your thoughts, leave a comment!