Are the free mySQL GUI tools adequate for administering a mySQL db running 'vendor' supplied applications?

Are there other tools you would recommend that make your life easier?

closed as not constructive by voretaq7 Aug 25 '12 at 3:14

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.



  • phpmyadmin - been around for ages & packed with features
  • SQLYog - which used to be open source, but now offers a 'community edition'

There's also MySQL Administrator which is provided by mysql although I've never used it.

Other tools: For backup:

  • zmanda offer a community version backup tool
  • xtrabackup as mentioned by pQd is fantasic & open source

i'm surprised maatkit was not mentioned yet. it does not provide any fancy gui applications, instead it gives dba set of command line tools that can be used to analyze mysql logs, diff and synchronize content of databases, run faster database dumps [ by executing parallel queries ]. you can read more here.

another useful tool - xtrabackup - free & open source hot backup of innodb databases.

  • yes xtrabackup! I've heard its awesome, i couldnt remember the name – Nick Kavadias Aug 22 '09 at 8:22

Navicat for MySQL (there are also Oracle and PostgreSQL versions too). Not free though. US$179 for the downloadable version ($189 for the CD). Highly recommended for all MySQL DBAs and developers using MySQL.

There is a trial version available as well.


Propably look into:

HeidiSQL - made my life easier


MySQL Workbench


PHPMyAdmin is a great tool.


You can also use : Database Workbench or SQL Manager or MySQL Maestro

Not the answer you're looking for? Browse other questions tagged or ask your own question.