Question

Write a note on open source software tools available in MySQL Administration.

Answer 1

Many open source tools are available in the market to design the database in a better and efficient manner. PhpMyAdmin is most popular for Web Administration. The popular Desktop Application tools are MySQL Workbench and HeidiSQL.

• PHPMYADMIN (Web Admin):

1. This administrative tool of MySQL is a web application written in PHP.
2. They are used predominantly in web hosting.
3. The main feature is providing web interface, importing data from CSV and exporting data to various formats.
4. It generates live charts for monitoring MySQL server activities like connections, processes and memory usage.
5. It also helps in making complex queries easier.

• MySQL Workbench (Desktop Application):

1. It is a database tool used by developers and DBA’s mainly for visualization.
2. This tool helps in data modeling, development of SQL, server configuration and backup for MySQL in a better way.
3. Its basic release version is 5.0 and is now in 8.0 supporting all Operating Systems.
4. The SQL editor of this tool is very flexible and comfortable in dealing with multiple results set.

• HeidiSQL (Desktop Application):

1. This open-source tools helps in the administration of better database systems.
2. It supports GUI (Graphical User Interface) features for monitoring server host, server connection, Databases, Tables, Views, Triggers and Events.