Personally I can't stand it. I think it's slow and clunky and the interface is horrible to use compared to native desktop applications under Windows (and you just can't fix it adequately with templates). There may be something available for PHPMyAdmin which we don't have, but I do like the syntax highlighting and ability to tab-justify my SQL in desktop apps which is one of my bug-bears in PMA.
I started off using MySQL Front many years ago, on the recommendation of someone on here I'm sure. That project was halted but HeidiSQL emerged from it and I've been using that since. I think MySQL Front is back, but I've stuck with Heidi since I've not had much reason to leave it (though the latest version appears to be missing (or hiding) some of my preferred old features, like the ability to export a DB/table directly to another server).
Anyway, I've been using Heidi at work as well, until last week when I suddenly couldn't connect to our dev-server. When I queried it with the boss he said that because of various data-protection issues we now had to use PHPMyAdmin which we connect to via SSL (the server is physically maybe 8 feet behind me mind you) and it's unlikely that I'll be able to use Heidi any more.
I discussed this with a colleague who doesn't understand my reluctance to use PHPMyAdmin. He seems to think that it does everything that Heidi does and does so perfectly quickly enough (I'm a big fan of web-apps, but I don't believe that they can out-perform a desktop app at all). He says "plenty of people use PHPMyAdmin, so it can't be that bad", which lead me to the question: How many people use PHPMyAdmin by choice?
I can honestly only think of the following reasons to use it:
- Your host doesn't allow you to connect directly
- You need to be able to access the DB from anywhere
- You use an OS that doesn't have a decent MySQL GUI available (includes mobile phones)
So, would anyone mind giving me your thoughts?