freeware mysql interface program needed

recommendations

[pixeltierra]

I've tried sqlyog (the only one that seems to work), mysql Front (no longer free, mysql Administrator (unusable).

Does anyone know of any good freeware desktop (not web) apps to interface with sql / mysql?

Sticky me please if you are not allowed to give product names here.

[webdoctor]

mysql Administrator (unusable)

Why do you find MySQL Administrator unusable?

It's now distributed as part of the MySQL GUI Tools [dev.mysql.com] bundle. I use it every day.

[pixeltierra]

I can't figure out how to view my data. It seems to be used less to manage data and more to manage the server.

[bcolflesh]

phpMyAdmin can be used locally, just like any client-side software you mention in the parent post.

[FalseDawn]

You can't view the data in MySQL Admin - that's one thing I really don't like about it.

Personally, I just create an ODBC datasource (you need the mysql ODBC driver) and use good old MS Access to link to the tables and use that to view/edit data.

[pixeltierra]

thanks the confirmation falsedawn,

What else does unusable mean? I can't believe mysql doesn't even make a client to manage data. I found the program sqlyog about a year ago and it's pretty good. At that time there were 4-5 freeware options for db admin, but now there seems to be none, as even sqlyog has gone commercial

[webdoctor]

how to view my data

You need MySQL Query Browser for that... it's also part of the GUI Tools [dev.mysql.com] bundle.

I can't believe mysql doesn't even make a client to manage data.

err... it seems you haven't looked very hard :-)

Try Query Browser, browsing queries is what it's good at.