Compare Navicat to other MySQL GUI tools?

Hello All,

I am new to PHP and MySQL, though I am learning at a good pace.  I have Adobe Web Premium CS3 and desire to move into dynamic, database driven websites using PHP and MySQL.  While I have been successful thus far using phpMyAdmin for working with MySQL DBs, I would much prefer to have an easy-to-use (possibly wizard-driven) and attractive GUI for creating and managing MySQL DBs.

My budget is "around" $100 for a commercial product.

I have looked at Navicat and SQLyog MySQL GUI, as well as SQL Toolkit for MySQL and MySQL Administrator, though I have tried none yet.

It seems Navicat is the most popular, but I am open to other suggestions and would like to know pros and cons, as well as differences between the product you prefer vs. Navicat.

Any recommendations?

Thanks,
edsager
LVL 2
edsagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
I have been surprised by this free tool:
www.quest.com/toad-for-mysql/ 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dr_dedoCommented:
there is few tools from mysql that reaaaly eases things up, query browser, admin and migration kit, supurb and free, and above all, from the very maker of mysql :)
haven't tried toad that angel mentioned, but sure i'll have a look !!
0
edsagerAuthor Commented:
I installed and tried Navicat, Toad and Query Browser-Administrator-Migration Kit.  The GUI with the Query Browser-Administrator-Migration Kit was not very attractive and confused me a bit, though it seems to be a powerful tool.  I was not impressed with Navicat, as it seemed a bit confusing, but I was VERY impressed with Toad.

Does anyone else have any comparisons to the above tools or with any other tools?

Thanks,
edsager
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

edsagerAuthor Commented:
It appears there are no comparisons & contrasts, so I shall award points.

Thanks,
edsager
0
neidenCommented:
I have been developing in the windows world(read mssql) for about 10 years now and recently took on a client using mysql.  

So I was looking for a gui for mysql that most closely compared to enterprise manager / management studio for mssql. My client had been using navicat which I found lacked many of the features I had grown accustom to in sql server. Such as intelitype auto completion and directory style table browsing with lots of "right click" menu options.  

After doing all my google searching for "mysql gui" and "navicat vs" and "navicat competitors" I found SQLyog... Not sure what "yog" is all about but after downloading the 30 day trial I found that this gui was definitely the best tool for mysql development in my opinion. I'm also quite certain that anyone coming from a sql server background would agree.

I love that you can even expand a table to see the column names and indexes without actually loading the table into the main window.

Anyway, I'm sure you've found something by now... if not, I hope this helped


0
neidenCommented:
Oh, I should probably have noted that it's not free... a single user license is 99 bucks but that seems pretty cheap considering the functionality.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.