The easiest way to install them on Ubuntu is to use Ubuntu package manager, either command line:
sudo apt-get install mysql-adminOr inside System | Administration | Synaptic Package Manager, search for "mysql-admin" and "mysql-query", mark them for install, and then apply the changes.
sudo apt-get install mysql-query-browser
After installation is complete, open a terminal and run command
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
cd /opt3. To run MySql Administrator and Query Browser:
sudo tar xzf $HOME/Desktop/mysql-gui-tools-5.0r12-linux-i386.tar.gz
/opt/mysql-gui-tools-5.0/mysql-administratorYou may also want to copy/move/link
$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/mysqldirectory, to group all mysql-related programs under one umbrella. But I had this error when running
(mysql-administrator-bin:11880): libglade-WARNING **: could not find glade file '/home/me/mysql/share/mysql-gui/common/preferences.glade'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.
terminate called after throwing an instance of 'MGGladeXML::Error'
In addition, the update-paths command doesn't seem to update path for Query Browser, since MySQLQueryBrowser.desktop file still has paths under /opt.