Dawn of Light

I've prefer standart mysql client (: and phpmyadmin(many functions, many languages, easy to use - official page(require webserver and PHP installed)).

Google: WAMP (Windows, Apache, MySQL, PHPMyAdmin)
Google: LAMP (Linux...)

Saves the time, as it's an all in one package.

i personally advise VertrigoServer as WAMP.

why ? because he also includes a SQLite DB tools, and i plan to work with SQLite soon. He also is very simple and intuitive.

For me, phpmyadmin is great for web access and export/import, but mysql gui tools is very comfortable for local work. very very. It just lack good import/export features.

I always woundered why so many people use Navicat.

SQL Query Browser has everything in needed for editing, adding and deleting,...

..and if you need to import/export database dumps just use "mysql -uUSer -pUSER DB <FILE" and "mysqldump ..." - No need for any extra tool

Navicat's Really simple and.. really simple to "purchase"

I have to rant.

Navicat is great, navicat is really simple, but navicat is what everyone has problems with. The MySQL GUI tools just work. Apparently the smoothness of operation and lack of not working confuses people so instead they opt for something that just doesn't work so they can come here and converse.



/rant

and, mysql query browser also let you to enter direct SQL if you want.

For me, it is choosen:

- mysql querybrowser in most cases (script support, embedded help, clic for common operations like delete modify, support for tabs...)
- phpmyadmin on server local admin, ie my provider is not opening 3306 -> phpmyadmin
- SQLyog (free version) for various import/export tasks. around 1 time per year !

Notice SQLYog is a good tool, but its GUI is finally not so simple as mysqlQB. But this is because i have habitude of mysql qb i 'll use it (rhaaa tabs!!), it is a good tool with good abilities and more (direct copy from DBx to DBy, as said dump, sql, csv in both import and export ...)

Tola, what is meaning "to rant" ? :p

Navicat MySQL v8.0.25 -PM me if you need link.

I am using Navicat and sqlyog, find them very comf`table

I know this is an older thread but I found a different SQl program that I find pretty nice to use and it's free!


http://www.heidisql.com/?

I think it's much better than the MYSQL GUI tools....

it is a good tool, yes, but better than MySQL gui idk, the separation between admin (backup, restore, user mgmt,...) and exploitation (queries, table changes,...) is a nice feature. Also, on Heidi, changes are committed at once. But yeah, this is a good free tool

I've prefer standart mysql client (: and phpmyadmin(many functions, many languages, easy to use - official page(require webserver and PHP installed)).

http://www.easyphp.org/

Has phpmyadmin pretty easy to use.

I use HeidiSQL too.

Holy necroposting batman!

Also.

For quick modification when you hate to write SQL by hand.
http://www.linqpad.net/