Database Management Tools 1

[uniopp]

Hi,
I've been having problems with MySQL Control Center and have decided to try some other solutions. I've narrowed it down to the following two (unless anyone has a better solution) -
Navicat

http://www.mysqlstudio.com/product.php3

Sqlyog

http://www.webyog.com/sqlyog/index.html

They are both good. I don't know which one to use, I like Navicat's simple layout but I think that Sqlyog may have more features. I also tried MySQL Explorer -

http://www.mysqltools.com/mysqlexp.htm

which also includes a nice diagram feature. Anyway they all have 30 day trials so I'll play around with them for a few weeks.

If anyone has any feedback on these products I would be most interested.

Thanks
Simon.

#### Duplicate posting on dbforums

 

[MrBelfry]

Have you tried phpmyadmin?

MrBelfry

 

[uniopp]

I looked at it but haven't tried it. I didn't think it looked that user-friendly (for a novice) compared to the other solutions.
What are some of the advantages?
Thanks.
Simon.

 

[MrBelfry]

phpmyadmin was the first thing I used on a remote host and I found it pretty easy to use. It was slightly trickier getting it to work on my local machine but the config file basically just involves finding the right place to put your password.

Big advantage is it is free but you do need php and also looking at the urls you gave it doesn't appear to be as fully featured and the interface doesn't seem so nice

MrBelfry