According to <http://dev.mysql.com/downloads/gui-tools/5.0.html>,
MySQL Query Browser and all the MySQL GUI Tools Bundle have been
replaced with MySQL Workbench. So I install that and... how is that a
replacement? I can't figure out at all how to create databases in
MySQL Workbench or perform queries. Maybe it's possible but if so
it's a horrible interface. MySQL Query Browser was really quite
intuitive and MySQL Wordbench appears to be backpedaling more than
anything else.

yawnmoth:

Well, opinions about MySQL Workbench may vary (I like it, and they are
working hard to make it even better in a fast pace), but it sounds as
if you're using the wrong tool.

Managing databases and performing queries are best done in phpMyAdmin.
It's the tool of choice for such work.
Workbench, on the other hand, is wonderful for modeling work. The
graphical interface allows you to "see" your database structure, define
field types, check consistency and import/export the lot.


--
Erick

On Mar 12, 1:05 am, "Erick T. Barkhuis" <erick.use-... (AT) ardane (DOT) c.o.m>
wrote:
Personally, I like MySQL Query Browser better than phpMyAdmin. Just
seems lighter weight and faster to me than phpMyAdmin. I also prefer
it to the mysql command line tool. The fact that there's a scroll bar
and that you can edit stuff in the database without having to write an
UPDATE query is just really convenient. I guess phpMyAdmin offers
that functionality, too, but I dunno... you just have to go through
more mouse clicks to use it. Or something. Also, MySQL Query
Browser's easier to install, imho.

yawnmoth wrote:
Much depends on the version of MySQL Workbench, those 5.1 versions I have used
(early ones) didn't include the "Query database" feature, but you will see it
in the beta version 5.2, it's still not up to date with the
mysql-query-browser, as you can't edit the values and commit it to the
database, but you can export the results.
The only thing that I see is better in MySQL Workbench is that you can do
multiple sql queries at the same time, which results in multiple result tabs.

At work I use both mysql-query-browser to make sql queries and editing values,
I use the MySQL Workbench for database designs, as it gives me a visual
picture how tables, views and so on are connected to each other.


The 5.1 which is the stable one, it's quite horrible and there are still many
options missing in 5.2 and there are things that could have been done, for
example EER Model editor, should be simple to switch color of an excisting
table, just a drop down menu and not have to write the hex color code.


I have to agree, and then you have the problem of the security issues with
phpMyAdmin, with a user who don't keep track of things, may offer his locally
installed phpMyAdmin to the whole world, which could in worst case result a
bad experience.

Sadly the update feature don't work that well if you use joins, which is a
feature I miss in the original query browser, but can be done with a sql query
instead.


Yes, phpMyAdmin do support that, but you will load a new page with one record
to edit (at least on the ancient version I used in the dark ages), which can
be a pita if you want to edit many rows this way.


--

//Aho

On Thu, 11 Mar 2010 21:40:02 -0800 (PST), yawnmoth wrote:
SQLyog's kinda nice. You may have to fuss around a bit to find the
community edition.

--
Or the "If you have the right to say whatever you want, then I have
that equal right to say that you're a worthless goat-fucker who should
do the world a favor by committing suicide with an electric wool
shearer." -- Charles the Gruamach, in a.g

On Mar 14, 5:23*pm, "Peter H. Coffin" <hell... (AT) ninehells (DOT) com> wrote:
http://code.google.com/p/sqlyog/downloads/list

Looks useful - thanks!