What's the best MySQL admin tool?
I've used a few different ones and as great as phpMySQL is, it's not always the most practical option.
- runs on Windows
- can run multiple commands at once
- be able to do schema or data import and export
- be able to return a table and edit in place
- code colouring and code completion are nice to have's but definitely not necessary
My demands aren't much but I've been disappointed by the selection. Maybe I just haven't looked hard enough. Can you recommend a usable, functional MySQL admin tool?
I have had great luck with mysql-front in the past, but my current host doesn't allow external connections.
MySQL-Front is definitely nice. On the free side, I like EMS MySQL Manager Lite (http://www.sqlmanager.net/en/products/mysql/manager) -- it's not 'lite' at all, though.
Have you tried out Navicat? Although I am not sure if it fulfills all your needs, it's my favorite MySql admin tool when I have to work on a windows machine.
I've always used phpMyAdmin, nothing else.
navicat. worth every penny
What is phpMySQL?????
I second Navicat. Easily my favorite db manager.
I have recently come across Aqua Data Studio and it is pretty slick. Free for personal or educational use too.
Well, there is always sqlyog (http://www.webyog.com/), available in free and pro editions... haven't really compared it with any other programs though... I just needed it to do a big batch job once, and promptly forgot about it
I'm using phpMyAdmin for extensive tasks and TurboDbAdmin for quicker stuff.
TurboDbAdmin is not really what you're looking for, but I thought i'd leave the link anyways.
( I'm not affiliated with them in any way. ;) )
Have you worked your way through the list that Particletree posted a while back?
Navicat looks pretty great; unfortunately my host blocks external connections too.
I've used SQLYog enterprise for quite a while, and I'd put in up there with MS SQL enterprise manager/ query analyzer in terms of functionality.
I'm sure there's a free download, so try it out.
I'll add my vote for SQLYog aswell - I've been using the free version and it does a grand job... very easy to use
I'm using "EMS MySQL Manager 3". Works really well even though I sometimes feel it has a little too many features.
Great site you have. Thanks for sharing.
Learn just the least bit of REBOL and you can have your command-line-based administration on practically any platform. See http://softinnov.org/rebol/mysql.shtml for details.
MySqlFront does the job for me
Actually, I just tried SQLyog and it works really nice.
I'm not really particular with any specific MySQL tool, and overall I tend to use the mysql command line the most.
I've used Navicat previously, which I only used it to import CSV data to mysql. Although its not bad.
MySQL Administrator 1.1 is nice for handling the administration.
MySQL Query Browser generally has quite a number of bugs.
Although designing database schemas, I would have to say DBDesigner from FabForce...
Anyway hope that helps a little.
Navicat is quite good
DBManager Professional from DBTools is hard to beat. I think it ticks all your boxes and can be used for other databases as well, MySQL, PostgreSQL, Interbase/Firebird, SQLite, DBF, MSAccess, MSSQL Server, Sybase and Oracle.
I have tried a few and the best I have come across so far is sqlyog from http://www.webyog.com/.
Especially the enterprise version with ssh tunneling
I am a fan of EMS Sql Manager.
Put me down as another tick against sqlyog, it is by far the best one I've tried for MySQL and the free version is enough for most needs.
Ever make a choice?
Yes, actually. I'm using SQLYog and have found it to be more than sufficient. Some of the table editing features are still a little quirky (like using enum fields) but once I figured it out, I was good to go.
SQLYog is sufficient for me, and when not available, PHPMyAdmin does the job - this of course only if console is not available.
no doubt, Navicat! Super fast and easy to use, I vote for it!
I prefer dbForge Studio for MySQL!