Open Source
MySQL GUI Tools (Query Browser, Administrator) for Fedora 13
Email This Post
⋅ 
Print This Post
⋅ 
Post A Comment 
@shekharg
In Fedora Linux, the mysql-gui-tools package provides the graphical (or GUI) clients to query and administer a MySQL database – useful alternatives to the command line client.
While I’m very comfortable with the mysql command line client, I do switch to the GUI query browser to add/edit stored procedures/functions.
“yum install mysql-gui-tools” was the simplest command to install the GUI tools for MySQL in Fedora Linux. But in Fedora 13, this results in “No package mysql-gui-tools available”.
So what happened here?
Why Fedora 13 repositories don’t have mysql-gui-tools package ?
The reason for this is explained in a bug report here. In a nutshell, the explanation is, the MySQL GUI tools is purposely removed from the Fedora 13 repositories because they have been buggy! Fair enough – it has crashed on me many a times.
But what is the alternative? The thread in the bug report suggests that it will be replaced with MySQL Workbench. That’s great! MySQL Workbench has many more features. So now can I issue a ‘yum-install mysql-workbench’ to have it installed on Fedora 13? The answer is no. This is because the bug report sums up with the following note:
mysql-workbench has not finished its review yet. this is due to the enormous
amount of work needed as the mysql team follows lots of bad practices.
Until we can cleanly and sanely package mysql-workbench there will be nothing
available on fedora.
The above reply is dated June 17, 2010. A 'no release date' left me desperate to look around (google).
The solution
There is always a solution and Google leads us to it. In a nutshell, I installed MySQL Workbench from the Remi repository. A quick install of MySQL Workbench, on Fedora 13, is as follows:
- Login as root
- Open a terminal window in GNOME/KDE or switch to the command line
- Issue the command:
rpm --import http://rpms.famillecollet.com/RPM-GPG-KEY-remi
- Next, issue the command:
yum install http://rpms.famillecollet.com/remi-release-13.rpm
- Open the file named remi.repo, found in the directory /etc/yum.repos.d, in a text editor (say vi) and change line no. 5 from:
enabled=0 to enabled=1
This will enable the [remi] repository. - Finally issue:
yum install mysql-workbench
to install MySQL Workbench on Fedora 13.
Henceforth, MySQL Workbench can be launched via a terminal window by issuing mysql-workbench or it can be found under Applications >Programming in GNOME.
loading...
loading...
Tags: Fedora 13, Linux, MySQL, mysql administrator, mysql gui tools, mysql query browser, mysql workbench, remi repository
Email This Post
⋅ Print This Post
⋅ Post A Comment @shekharg
Discussion
12 comments for “MySQL GUI Tools (Query Browser, Administrator) for Fedora 13”
Post a comment
Hi Shekhar,
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
Can you let us know the problems you are seeing on Fedora 13.
- MySQL Workbench
loading...
Hi MySQL Workbench,
Thanks for the comment and for the wonderful product!
None so far. Have been using it ever since this blog post
.
Will certainly let you know in case I face any issue(s).
loading...
Awesome, thanks! Although, mysql gui tools never broke down on me on Fedora12.
A note though: the command is rpm –imporpt, not rpm -import. Your blogging software changed the — to an EM dash.
loading...
Thanks Victor. Have enclosed the commands within HTML PRE tag pairs. Thanks again for pointing this out.
loading...
Hi Shekhar,
Was looking for an interesting topic and found yours. I want to introduce dbForge Team software – development and administration tool for MySQL.
dbForge Studio for MySQL is the MySQL management and administaration tool combining features of phpMyAdmin, MySQL Administrator, and other MySQL GUI tools (MySQL Front Ends). It works with any MySQL database server from version 3.23 up to 5.5 and supports most of the latest MySQL features including Stored Routines, Triggers, Views, Functions, Events, etc.
loading...
This is toomuch usefull
Thanx a alot
loading...
very much helpfull thnx a lot!
loading...
What about Fedora 12?
I am totally new!
loading...
Hi Waleed,
On Fedora 12, you can use MySQL Query Browser which can be installed via the command “yum install mysql-gui-tool”.
loading...
Workbench doesn’t have the option to create databases and tables. It’s useless
loading...
Hi chewa,
Not really. In MySQL Workbench, under the Actions pane (on the left), using “Add Schema” you can create a new database and using “Add Table” you can create new tables within a selected database. Make sure that the MySQL user that you are using for login has privileges to create database and tables. Refer to the following URLs to set the privileges:
http://dev.mysql.com/doc/refman/5.1/en/grant.html
http://pcquest.ciol.com/content/linux/101110601.asp
loading...
Very very thanks for you
It is really good…
loading...