up vote 7 down vote favorite
1
share [g+] share [fb]

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?

link|improve this question
100% accept rate
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
show 2 more comments
feedback

7 Answers

up vote 5 down vote accepted

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" ;-)

link|improve this answer
Do we need to migrate these sorts of questions from SO then? – jcolebrand♦ Jan 10 '11 at 3:38
feedback
up vote 2 down vote

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.

link|improve this answer
feedback
up vote 1 down vote

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.

link|improve this answer
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
feedback
up vote 1 down vote

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

link|improve this answer
feedback
up vote 1 down vote

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

BTW: I found it on Alternativeto

http://alternativeto.net/software/dbfacephp-for-mysql/

link|improve this answer
feedback
up vote 0 down vote

You can use Chive

http://www.chive-project.com/

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).

link|improve this answer
feedback
up vote 0 down vote

Believe it or not, although the products went EOL December 18, 2009, the last versions of MySQL Query Browser and MySQL Administrator are still available for download. Hey, I still use them today.

While many people have switched to MySQL Workbench, some have found themselves not satisfied with it and want to go back to the old, but trusted, MySQL GUI Tools Bundle.

** It is still available for download FOR FREE !!! **

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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