Does any body know of a front end GUI for MySQL. I was hoping to find one that would have some if not all of the following features: design custom inventories query edit I have a database to keep track of all of my clients but I need sometime much more flexible. For example my database has all of my clients information which is pretty standard but then if I buy my client a computer I would like to be able to add fields to that client to insert information about the computer my reference later. I dont want to have to predefine all of my fields but be able to add on things when they come up. Does anybody know of anything that can do this?
MySql has released some GUI tools that you can use to edit your database schema and data. Take a look at Mysql Query Browser and MySql Administrator: http://mysql.com/products/tools/
My favorite is Navicat: http://www.navicat.com/ They have a light (Free) version, and the full featured commercial version. I like it a lot better than the Mysql Admin or Query browser.
Thanks for the response. Im going to try those and see if they have everything im looking for. Does anybody else have any ideas?
phpMyAdmin is probably the most used web ui for managing MySql: http://www.phpmyadmin.net/home_page/index.php
I'm using phpMyadmin too. Pretty easy to use and can manage all general database usage that you need.
mysql query browser is pretty good, but pretty buggy at the same time. No real serious bugs like destroying data just UI bugs like disabled checkboxes etc...I think it has gotten better over the past year... Personally I go hard core and shell into the console
do you actually use phpmyadmin to add / edit records in your database or just to set up your databases?
I have in a pinch. But day to day, I wouldn't dream of using it. Most of the apps I have seen are admin style. Not really designed for end use.
If you want to go quick and dirty you might achieve the functionality you are looking for in MySQL Query Browser. Just save the queries (ie custom inventories) that you use as sql files and open them as needed, and use the interface for add\edit delete stuff. Tools like Toad offer similar functionality and that might work too. If I understand you correctly you want a custom interface, what we refer to as a CRUD (create, retrieve, update, delete) application, which is really common and for which exists lots of frameworks. This is mostly done though a web interface and in PHP or Java or ASP, but can also be done as a standalone desktop program in VB or C#. In this case, you might want to hire a programmer through rentacoder or some such site, but you will likely need to pay more than $100. If it's not worth this much to you then maybe just use MySQL Query Browser.
It does sound like you are looking much for a data maintance program than an SQL administration tool and as such it is much more common to have these custom coded (web or desktop) rather than find off the shelf solutions which are much more aimed at DBA
That does sound exactly like what im looking for. Im going to give the other ideas a try and see if they will work for me. Thanks everybody for your input.