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!

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

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 :) !

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

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.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

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.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

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 :)

__________________