MySQL is the most popular open-source database. Whether you’re an aspiring web application developer or a person working on an existing database-driven web application like a content management system, ecommerce platform, or blogging platform — there are a variety of handy applications that you can use to make MySQL database design and administration (relatively) a breeze. So if you find yourself in a position where you have to work with MySQL, you don’t have to use a command-line interface, check out these 7 outstanding applications to help you create, write, manage, and visualize your database.
Turbo DB Admin
- turbodbadmin
A browser-based solution for exploring and editing databases without having to refresh or submit.
EMS SQL Manager for MySQL is a high performance tool for MySQL database administration and development. It works with any MySQL versions from 3.23 to the newest one and supports all of the latest features including MySQL triggers, views, stored procedures and functions, InnoDB foreign keys, Unicode data and so on. SQL Manager for MySQL allows you to create/edit all MySQL database objects, design MySQL databases visually, run SQL scripts, import and export MySQL database data, manage MySQL users and their privileges and has many other useful features for efficient MySQL administration. SQL Manager for MySQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
- MySQL GUI Tools
The MySQL GUI Tools Bundle for 5.0 includes the following products which are also supported for MySQL 5.1.
- MySQL Administrator 1.2
- MySQL Query Browser 1.2
- MySQL Migration Toolkit 1.1
phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
- instantsqlformatter
Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily. In addition to beautifying SQL code, this sql tool can translate SQL code into C#, Java, PHP, DELPHI and other program languages. Another useful feature is find out all database objects such as table, column, function in sql by selecting output format to list database object.
- DB Designer 4
DBDesigner 4 is developed and optimized for the open source MySQL-Database to support MySQL users with a powerful and free available design tool.All MySQL specific features have been built in to offer the most convenient way to design and keep control of your MySQL-Databases.
- WWW SQL Designer
WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.
-Ramesh
This entry was posted on Wednesday, December 9th, 2009 at 12:09 am and is filed under SEO & SEM News. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
