When comparing DbVisualizer vs PHPMyAdmin, the Slant community recommends PHPMyAdmin for most people. In the question“What are the best MySQL management tools?” PHPMyAdmin is ranked 2nd while DbVisualizer is ranked 4th. The most important reason people chose PHPMyAdmin is:
Editions can be performed over a result table just by clicking the desired field.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Professional tool
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.
Pro Duplicate row button
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.
Pro Wildcard finder
Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns).
Pro In-line editing
Allows you to edit and save db rows through a spread-sheet like editor.
Pro Easy to edit
Editions can be performed over a result table just by clicking the desired field.
Pro Available in most hosting services
Because of its portability, popularity and robustness phpMyAdmin is included in most hosting services that support the LAMP stack.
Pro Easy installation
The installation process itself is very simple, you need to have PHP and MySQL installed on your server, extract the files to a specified directory and run the install script. If you get stuck somewhere there's a lot of help online. The official wiki is very good too as far as the installation goes.
Pro Complete functionality
phpMyAdmin is complete as far as features and functionality go. You can even build a full website without knowing any MySQL.
Pro Portable
phpMyAdmin can run in a web browser, this makes it a very portable tool because it can be run on any computer and on any OS as long as it has a web browser installed.
Cons
Con Expensive
License for the full product is costly.
Con Confusing interface
It may take some time to get used to it.
Con No schema visualization
Con No code higlighting
phpMyAdmin does not have any code highlighting or auto-completion capabilities, unlike other options.