MySQL, a free database engine, is a popular choice among webmasters. Despite its popularity, it is still difficult to visualize the database, table, fields, and data. Though there are many great php web interface solutions available, there are not many software based solutions. My favorite solution is Toad. It is powerful freeware for MySQL and available for download. If you have ever used Microsoft’s SQL Server software, the Toad user interface is will feel similar.
You are given a visual representation of your databases. Select a database and drill down to view the tables. From the tables, you can view either the existing data or view the columns. In addition to viewing the existing tables, you can create new tables, columns, and insert new data.
All in all, Toad is a great free option for MySQL users. If you have never given it a try, I highly recommend you give it a test drive. Included in the functionality is Version Control, Integration, Macro Record and Playback, Database Browser, Security Manager, Knowledge Xpert, Project Manager, SQL Recall, Code Formatter, Import/Export, Analyze Table, Check Table, Compare and Sync, Create/Drop Database, Kill Session, Change Database Variables, Customizing toolbars. Toad has been developed by Quest and can be found at http://www.quest.com/toad-for-mysql/