Okay, so it seems that phpMyAdmin basically beats everything else.
Although I find some of it hard to use, overall it gets the job done.
Thanks for your responses!
I use phpmyadmin because despite it being complicated, it enables you to do a lot of useful stuff without having to actually worry about the more complicatd sql queries.
I have been using Navicat. Its a good client. I have used heidi sql also. Its also a good one. But currently i am using Navicat. It has all the option. But unfortunately, i cannot connect it to x10 server. But it can also be used to connect to remote mysql servers. various option like ssl support is also included.