Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this 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

6 Answers 6

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

share|improve this answer
    
Do we need to migrate these sorts of questions from SO then? –  jcolebrand Jan 10 '11 at 3:38

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.

share|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

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.

share|improve this answer

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

share|improve this answer

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

share|improve this answer

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/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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