[jiggy2011]

Fantastic , I hope it will work for mysql too.

For DB admin the only nice simple tool I've ever found is SQLYog which is Windows only.

PHPMyadmin doesn't have a very nice user experience.

I don't need a massive feature set, just something that allows me to fiddle with testdata easily, define and edit table structure and do things like copy tables, DBs between hosts with a couple of clicks.

[culturestate]

If you're on OSX, have you given Sequel Pro a try?

[jiggy2011]

No, on linux so a web app of some kind would be ideal.