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:
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'
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.


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


Unknown 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

Anonymous said...

You can check free tool Valentina Studio, which I think is far superior to other GUI tools.

Java 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

Unknown 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.

Unknown 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

Unknown said...

I enjoyed on reading your blog post. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. Please visit my website, Friv 4000 Games is where all the free friv games.
Friv 4000

varunsharmaa91 said...

Thanks for posting useful information.You have provided a nice article, Thank you very much for this one. And I hope this will be useful for many people.. and I am waiting for your next post keep on updating these kinds of knowledgeable things...Really it was an awesome article...very interesting to read.
Selenium Training in HRBR Layout
Selenium Training in Kalyan Nagar
Best Selenium Training Institute in Kalyan Nagar Bangalore

Anonymous said...

You can check out this one powerful mysql gui tool. dbForge is wonderful for DB (MySQL and MariaDB) management, admin, and development.

eMexoT said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.

Dot net training in electronic city

Eduprism said...

Useful installation guide for mysql. Got knowledge about installation mysql. Keep sharing similar posts.

Salesforce training institute in bangalore

malar said...

Thank you for excellent article.You made an article that is interesting.
Tavera car for rent in chennai|Indica car for rent in chennai|innova car for rent in chennai|mini bus for rent in chennai|tempo traveller for rent in chennai
Keep on the good work and write more article like this...
indica car rental in chennai for outstation
Great work !!!!Congratulations for this blog

malar said...

Java online job support from India
Android online job support from India
PHP online job support from India
Mainframe online job support from India
ReactJs online job support from India
MicroStrategy online job support from India
Dot Net online job support from India
DevOps online job support from India

web development company in hyderabad said...

After reading this blog, I have good knowledge on how to install it.

KITS Technologies said...

SAP Secrity online training
oracle sql plsql online training
go langaunage online training
azure online training
java online training
salesforce online training
hadoop online training
Data Science online training

kloudportal said...

Nice Post, Digital Marketing Agency in Hyderabad