Database Administration tools?
 

What DB Administration tools do you guys use/recommend? Personally im a fan of SQLYog, however i have used the Mysql.com Admin Tools in the past, but they are a little weak.

I however, definately havent used SQLYog to its full capacity and it is still far better than the Mysql.com Tools.

I use the tools from MySQL.com - they 'just work' for me, I've not needed to go and look for anything more. :)

I use SQLYog too, extremely powerful software. I did once look at the default MySQL tools, but I wasn't too impressed with them either (that was years ago though, so who knows where they have come since then).

Salathe, i'd recommend trying SQLYog, especially if you havent before, its mountains better than the mysql tools, offers much more flexability.

http://www.webyog.com/en/ They have a trial :)

Maybe I'm just being blind but I couldn't find an OS X version, bluesaga. :(

I prefer PHPMyAdmin - Crap and ugly looking but it always happens to do the job.

Ah im not too sure about OS X :( Sorry.

PHPMyAdmin offers nothing that SQLYog can, simply put.

Wow, Never knew of SQLYog. WildHoney told me about SQLYog website but I installed Monitor instead of the GUI to manage the database. Lol, silly me. :(

The program I always use is: Navicat.

It's definiately worth trying it out!

http://www.navicat.com/

Never heard of Navicat before but it looks quite nice. Is it a powerful tool? I use SQLYog which I wouldn't put in a corner for anything else, but it's still worth asking about Navicat!

I use PHPMyAdmin too. As localhost mentioned, it just works. Also, its linked in my hosts control panel, so its the most convenient.

Trouble with phpMyAdmin is that it's just too messy :( Everything about it is yuk. Don't get me wrong, I used to use it, then I discovered stand-alone applications such as SQLYog that, well, just work, too :) !

Yeah I hear ya. It is rather messy and ugly. It does load kind of slowly for me sometimes too, so maybe I'll check out some stand alone ones like SQLYog. :)

Only trouble with stand-alone applications like SQLYog is that you first have to enable your host to connect. Typically they're just configured to allow localhost to connect by default - which means phpMyAdmin.

Oh well my host doesn't use localhost. They have their own address, so would it already work?

It's a tough one. Probably not. They've probably only allowed their hosts to connect. Your host would be more than happy to add another host to the allowed list - or if you have an administrator area, such as CPanel, then you can do it from in there.

Great. Thanks for the info! :)

Gurnk - If you use cpanel, before you click "view phpmyadmin" there should be something there for "hosts" normally it just has "localhost", if you add "%" it works as a wildcard and allows any ip address to remotely access your database (with the correct credentials).

Or you could simply allow only your own IP to access it by entering that instead of "%"

Trial ended two days ago.

And I bought the product after getting annoyed with phpmyadmin.

You can also use it to only mask part of a hostname. E.g. %.cable.ubr04.edin.blueyonder.co.uk :)