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. So here the 10 applications to help you create, write, manage and visualize your database.
TurboDB Admin: TurboDB Admin is a free web-based AJAX application that helps you manage, explore, and edit MySQL and PostgreSQL databases. It gives you the ability to export your database into a downloadable file which you can keep as a back up in case you need to restore your database. Installation is very simple, just upload the application to your web server, edit the config.php file to reflect your database information, and itâ€™s ready to go just navigate to your installation directory in your web browser to access the application. It works in Apache and IIS HTTP servers, and requires PHP installed and enabled on the web server.
SQL Buddy: A web-based MySQL administrator with an Ajaxed interface was designed to meet the demands of modern web developers and its completely open source and free for everyone to use. It uses the MySQL user table for authentication. Therefore, you can get started right away by using users that already exist. Most people will want to login as root because this level of permissions is necessary for certain tasks (like adding users, for example). However, you can login with any user that you wish.
HeidiSQL: HeidiSQL is a graphical interface for easy management of your MySQL server and databases. It allows you to browse your databases, manage tables, view and edit records, manage user-privileges and more. Furthermore, you can import data from text files, run SQL queries, synchronize tables between two databases and export selected tables to other databases or SQL scripts. It offers an easy-to-use interface with syntax highlighting for SQL queries and tabs to switch between database views. Other features include editing of BLOBs and MEMOs support for large SQL scripts, user process management and more.
My SQL GUI Tools: It is a bundle of graphical user interface tools that include MySQL Administrator , MySQL Query Browser and My SQL Migration Toolkit. MySQL Administrator is a GUI for managing databases and has database optimization features, rapid back up and restoration of databases, access to log and error file and more. MySQL Query Browser gives you a script editor that can help easily edit and debug troublesome queries, among other things. MySQL Migration Toolkit allows you to simplify the process of transferring MySQL databases into other server environments, providing features such as remote server-to-server migration and optimization of migration processes by creating scripts you can run again if you move or copy databases frequently.
Php Myadmin: Php Myadmin is a browser-based MySQL database administration tool written in PHP. Itâ€™s my personal graphical interface administration tool of choice because itâ€™s simple to use and has a big list of features and options. You can easily export a database for back up or migration into another server environment. You can also import a database effortlessly. Optimizing a database is a one-click affair, and is useful to try if your web applications seem sluggish.
EMS SQL Manager: EMS SQL Manager for MySQL is a first rate graphical interface tool for MySQL database administration and development. It comes in two versions the full version and lite version which is still featured pack. The Lite version of the EMS SQL Manager for MySQL allows you to effortlessly create and manage users and permissions without having to use a command line interface. It also has several SQL editors that you can use that have syntax highlighting or coloring to make queries easier to read.
Instant SQL Formatter : Instant SQL Formatter is a web-based application that beautifies your SQL code. Itâ€™s not strictly a MySQL database tool as it supports other databases such as MS SQL and Oracle. It can output scripts for many popular languages such as PHP, VB.NET, Java and C#. Thereâ€™s also a desktop version that has added functionalities such as additional formatting options, batch conversion of files, and highlighting or colorizing SQL statements.
DB Designer 4: DB Designer 4 is another excellent visual database editor for MySQL. It allows developers to create and share plug-ins to extend the existing features of DB Designer 4. It has two modes Design mode which is a visualization tool for creating and maintaining databases, and Query Mode which lets the developer build complex SQL queries for use with PHP or another scripting language. DB Designer 4 also has a full set of documentation options to help you manage and record information about your database.
WWW SQL Designer:WWW SQL Designer allows you to model databases via your web browser. It is a great way to document your database design, just use the print screen function key on your keyboard , paste it into an image editor or word processing software and you will have a document of your database model. Once youâ€™re satisfied with the model, you can auto generate the MySQL code. WWW SQL Designer is a simpler alternative to more complicated desktop applications and if you just want to quickly create a database schema example, you can just use the without installing anything.
My SQL Diff: My SQL Diff detects the layout difference between two databases and creates the SQL ALTER statements that you can run in the live environment easily, to make it up-to date with DEV environment.