I currently use phpmyadmin for most of my database administration. It works well enough, but I'm interested in other tools that might work more quickly/efficiently/etc...

What are the best and/or alternative admin tools for MySQL on a *nix box?

closed as off-topic by Paul White, Philᵀᴹ, Max Vernon, Aaron Bertrand Jan 26 '15 at 14:52

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Philᵀᴹ, Max Vernon, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Are you looking for web replacements? Or native clients using the OS GUI? – Sebastian Roth Jan 4 '11 at 3:21
  • i'm looking for web replacements, almost all of my systems that I have db's running are linux servers, so no GUI – Patrick Jan 4 '11 at 3:24
  • @Patrick , yes GUI if you can connect from outside the server network . you can then use SQLyog , SequelPro ... or whatever desktop application you like best , such a desktop app would be faster and better than a web replacement . – poelinca Jan 4 '11 at 6:11
  • I think this should be retitled to indicate that it's for MySQL in particular, and not generically for all databases. ... idk, maybe just over pedanticness. – jcolebrand Jan 7 '11 at 18:31
  • @Brian ~ per the meta question I don't think we need to do this. meta.dba.stackexchange.com/questions/92/… – jcolebrand Jan 10 '11 at 3:38

A list of web replacements is available here:

And this question was asked before in Stackoverflow as well:

In my opinion, a alternative phpmyadmin should not just look good, but must at all cost keep up with security updates. If you are intranet user, it might be a different case, but I know from the early days of phpmyadmin that security is very important for anything involving "http and sql" ;-)

  • Do we need to migrate these sorts of questions from SO then? – jcolebrand Jan 10 '11 at 3:38

I myself use SQLyog:

SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools.

And sometimes use MySQL WorkBench:

is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single, seamless environment for the MySQL database system. It is the successor to DBDesigner 4 from fabFORCE.net, and replaces the previous package of software, MySQL GUI Tools Bundle.


Personally, I use Webmin(for MySQL on a Linux box). It lets you handle your databases mostly without needing any actual SQL. Also, it can do a host of other things including remotely installing modules, servers, if you have a mail server you can check the mail through Webmin too. You can change passwords, view logs, view cron jobs, and it has a shell too.

  • I thought webmin just rolled in phpMyAdmin and phpMyPostgresql? (or whatever, point remains) – jcolebrand Jan 7 '11 at 17:14
  • @jcolebrand: What do you mean by "just rolled in"? – John Jan 7 '11 at 17:36
  • "just folded in"? That the webmin toolkit didn't write their own universal database access methods, they merely used somebody else's toolkit as part of their own. – jcolebrand Jan 7 '11 at 18:30
  • @jcolebrand: I don't know if that is the case. When I read up on PhpMyadmin and Webmin, Webmin looked better to me so that's the one I picked. I find it incredibly useful and haven't used anything else since. or ever, for that matter(If you have something good, why change it?). – John Jan 7 '11 at 18:40
  • I'll do a bit of digging and let you know. – jcolebrand Jan 7 '11 at 18:56

There's also SQLBuddy, though unfortunately it seems it's no longer under development.


take a look DbFacePHP for MySQL, live demo there http://www.dbfacephp.com/mockup/index.php the best

BTW: I found it on Alternativeto



You can use Chive


What is Chive?

Chive is a next generation MySQL database management tool. The web-based user interface supports most of the common operations needed by software developers and database admins (databases, tables, indices, keys, triggers, views, routines, privileges management, import/export).

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