7/07/2008

Install MySql GUI tools (MySql Administrator and Query Browser)

The easiest way to install them on Ubuntu is to use Ubuntu package manager, either command line:

sudo apt-get install mysql-admin
sudo apt-get install mysql-query-browser
Or inside System | Administration | Synaptic Package Manager, search for "mysql-admin" and "mysql-query", mark them for install, and then apply the changes.

After installation is complete, open a terminal and run command mysql-admin or mysql-query-browser. If running them in an existing terminal, you may need to run rehash command first to include the new tools in PATH. Everything should just work.

I also tried installing the generic Linux tar bundle for MySql GUI tools, but had a couple of problems:

1. Download the generic Linux bundle (mysql-gui-tools-5.0r12-linux-i386.tar.gz) from http://dev.mysql.com/downloads/gui-tools/5.0.html . The bundle for Linux includes MySql Administrator and Query Browser (MySQL Migration Toolkit is currently only in Windows bundle).

2. To install the tools, just extract the archive. There are instructions at http://dev.mysql.com/doc/administrator/en/install-generic-tarball.html . Basically, execute this command to expand the downloaded file on Desktop to /opt:
cd /opt
sudo tar xzf $HOME/Desktop/mysql-gui-tools-5.0r12-linux-i386.tar.gz
3. To run MySql Administrator and Query Browser:
/opt/mysql-gui-tools-5.0/mysql-administrator
/opt/mysql-gui-tools-5.0/mysql-query-browser
You may also want to copy/move/link MySQLAdministrator.desktop and MySQLQueryBrowser.desktop to $HOME/Desktop, so you can double-click to launch them.

When running Query Browser, I ran into this issue: mysql-query-browser is freezing every way i try to pick, or click, a scheme. I tried removing everything under $HOME/.mysqlgui/ but still the same.

It's possible to install to directories other than /opt, but it may cause various troubles. I'd suggest stick to the default install directory /opt. I first tried to install under $HOME/mysql directory, to group all mysql-related programs under one umbrella. But I had this error when running ./mysql-administrator --update-paths:
(mysql-administrator-bin:11880): libglade-WARNING **: could not find glade file '/home/me/mysql/share/mysql-gui/common/preferences.glade'
terminate called after throwing an instance of 'MGGladeXML::Error'
Aborted
I then chose to install directly under $HOME so that mysql-gui-tools-5.0/ and mysql/ are at the same level. I also ran mysql-administrator --update-paths to update the paths. I was able to run MySql Administrator, but the GUI fonts are sort of blurred, probably because some GTK library cannot be found. This problem was gone once I changed to the default install location /opt/mysql-gui-tools-5.0.

In addition, the update-paths command doesn't seem to update path for Query Browser, since MySQLQueryBrowser.desktop file still has paths under /opt.

8 comments:

Anonymous said...

Thanks for the help.....

ankesh said...

thanks alot i found your post very useful now i am able to run mysql-admin as well as mysql query browser

THANX AGAIN

lala said...

Thanks for your post and welcome to check: here
.

juliaroberts said...

Best Software Downloads and Reviews. the most comprehensive source for free-to-
trysoftware downloads on the WebBEST 4
DOWNLOADS

hayatu-123 said...

You can check free tool Valentina Studio, which I think is far superior to other GUI tools.
http://www.valentina-db.com/en/valentina-studio-overview

Dara Yuk said...

It is very good site. I am also writing many useful Java programs for free learn. All Java fans can check them at www.javatheprogram.blogspot.com.l

tom cooper said...

hi guys, few days back i was looking for mysql gui tools . i came across datasparc.com where i found features to be super cool and stable and more compatible has powertools like migration toolkit from various like access, sql server, and also data, schema sync with much more powerful tools.

Steve Smith said...

Great and Useful Article.

Online Java Training

Java Online Training India

Java Online Course

Java EE course

Java EE training

Best Recommended books for Spring framework

Java Interview Questions








Java Course in Chennai

Java Online Training India