SQLyog vs DbVisualizer

The UI is uncluttered and intuitive.

Query builder is very intuitive and easy for designing very complex queries.

There is a free/community version available here.

There are very useful power tools to do task like database synchronization, visual data comparison, Schedule backup with email notification. One can also schedule task with scheduler and will get report of task completion or error in email.

User can enable session restore to avoid loss of unsaved work.

Completely written in c/c++ using win32 api gives is edge in performance over other clients.

It's possible to connect to any MySQL server with these powerful connection options - HTTP, SSH, SSL.

This is a good and stable tool with really good and useful functionality: import/export, SSH tunnelling, fast searching, duplication, DDL visualization etc. If you are a professional, don't complain about the pricing. If you're an amateur, maybe this isn't for you.

Makes it really easy to stub out example data while developing, just change the values with unique constraints and you have extra data ready to go.

Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns).

Allows you to edit and save db rows through a spread-sheet like editor.