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
- History of MySQL
- MySQL Database Administration Tools
- Licencing of MySQL
- Editions of MySQL
Developer: Oracle Corporation
Initial Release: 1995
Stable Release: MySQL Server 5.6, 2014
Written in: C, C++
Available in: English
License: GNU General Public License (version 2) or proprietary EULA
Website: MySQL site
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.