MySQL

MySQL is the world’s most widely used open source database management software. For its cost effective and high performance features it is commonly used with many programming language (especially PHP) to developed powerful and dynamic web applications. This article describes an introduction to MySQL database server. Summary of the article:

What is MySQL
MySQL is a Relational Database Management System (RDMS). It is open source. That means it is possible for anyone to use the software by downloading it from the internet and modify the software according to needs. MySQL is very fast, reliable, and easy to use. Under constant development, today it offers a rich and useful set of functions. Its connectivity, speed, and security makes highly suited for accessing databases on the Internet. It works in client/server or embedded systems.

History of MySQL
In 1995, MySQL was developed by a Swedish company MySQL AB. Its creator was Michael Widenius (Monty), David Axmark and Allan Larsson. Its name was taken from Michael Widenius’s daughter name “My”. MySQL AB is now owned by Oracle Corporation.

MySQL Database Administration Tools
Like others, MySQL does not provide any built-in GUI tools for database management and administration. User can use either command line tools or third party graphical tools. Lot of third party graphical tools (desktop software and web applications) are available for administration. MySQL Workbench is the official GUI tools provided by Oracle and it is totally free. Others available tools are: phpMyAdmin, HeidiSQL, Webmin, SQLBuddy, Toad for MySQL, Adminer etc.

Licensing of MySQL
The MySQL software is Dual Licensed. Users can either choose Open Source product under the terms of the GNU General Public License or can purchase a standard commercial license from Oracle Corporation. More information regarding licensing is available on its web site.

Editions of MySQL
The MySQL editions are given bellow:

MySQL Enterprise Edition

MySQL Standard Edition

MySQL Classic Edition

MySQL Community Edition

MySQL Cluster CGE

MySQL Embedded (OEM/ISV)

That’s all about MySQL.

About Author

Rashed

I’m Rashedul Alam, software engineer/architect, technical blogger, and educator. I have over 10 years of working experience in the field of software design and development. I like to share my knowledge and technical stuff with others. I am a community contributor, providing problem solving answer through different forum.