Searching for a program like Navicat 2004

[LeetViet]

Is there another program that will allow me to work with MySQL databases in Windows?

 

[Beau]

MySQLFront

Works pretty well, is in-expensive, and has frequent updates. It can be a little buggy sometimes, but overall it's good.

 

[LeetViet]

Originally posted by: Beau
MySQLFront

Works pretty well, is in-expensive, and has frequent updates. It can be a little buggy sometimes, but overall it's good.

Thanks, I was hoping for any freeware solutions before I purchase anything (if I do).

 

[Rodriges Antoni]

You can check one more new tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.

---

I don't know if you are spamming, but your reply bumped a thread that is almost nine years old.

Harvey
Senior AnandTech Moderator/Administrator

 

[ringtail]

phpMyAdmin

I finally settled on phpMyAdmin- after having at various times used Navicat, SQLyog, Toad, through MS Access, through Open Office DB, and a few more.

The only thing is- it's easy IF you find and follow good instructions for how to install it. Some of the install instructions are subtle, easy to miss, like the one about going into phpMyAdmin and importing some tables buried inside an "examples" directory which initialize the installation.
Therefore, it's helpful (to me at least) to read more than just one set of instructions, because some highlight what others gloss over.

For me on Windows 7 these instructions work real well, so maybe they'll work for you too IF you use Win7 :
http://connectwww.com/how-to-install-and-configure-apachephpmysql-and-phpmyadmin-on-windows/457/

I also have this bookmarked, but from so long ago that I'm not sure whether the info is still good...nevertheless, if it may help you here it is:
http://www.wikihow.com/Install-phpMyAdmin-on-Your-Windows-PC

The best way to use MySQL is command line.
If you want a GUI (I do too) then I really do think phpMyAdmin is about, or at least is among, the best front ends for using MySQL.

A lot of the installation challenge is about getting your "httpd.conf" in Apache set properly, and also and ESPECIALLY your "config.inc.php" file in phpMyAdmin.

Edit: This is the version of PHP I've had for a long time, and it's probably the best available version of PHP to install on Windows with Apache. It's real hard to find via the PHP web site, which is why I thought you might like this link to it:
php-5.3.5-Win32-VC6-x86.msi from http://windows.php.net/downloads/releases/archives/

If you don't go that route then another to look at is Toad for MySQL. It's real good too, and the MySQL version is free. phpMyAdmin is super intuitive to use while Toad for MySQL is sort of a learning curve. Oracle guys pay to use Toad, while its MySQL version is free.

 

[ringtail]

...and another option is to install this:
http://bitnami.com/stack/wamp

Personally I prefer to install the individual apps that comprise the stack, because I use some of them in other ways besides with MySQL.

The things in both this post and my other post above are all free.