That is an odd question....the "editor" part. There are a number of tools for MySQL, the most notable being phpMyAdmin. I would not call it a GUI application, but it is by far the most useful tool for MySQL.
Another tool for User Admin rights and access permissions would be MySQL Command Center. This is a Windows based application too and easy to use. I prefer using it over the phpMyAdmin tool which can do the same thing. This tool is a GUI app of sorts -- but I would not call it an editor.
MySQL Control Center can be downloaded at http://dev.mysql.com/downloads/ along with two others MySQL Adminstrator and MySQL GUI (no longer supported and programming is transferred to Control Center). I have not tried either of these two, nor do I know much about them ... but you can check them out there.
phpMyAdmin is available at http://www.phpmyadmin.net/home_page/ but most Web Hosting should have this installed as part of their service.
I have the feeling though that you are actually wanting to know something else here....perhaps you are looking for an interface similar to browsing and building apps like an Access database can with VBA, yes??? If so ... I cannot think of any that is available as Open Source (which I think you are looking for also). But there are some out there I think -- I just have not really looked that hard for them. If you want I can though.
I found this one really quick just now SQLyog which has a pretty hefty pricetag. Here are some screenshots. If this is what you had in mind, let me know.
Last edited by RonnieTheDodger : 05-18-2004 at 05:25 AM.
|