MySQL is a software management system SQL database (in English: database management system) or the DBMS that multithread, multi-user, with around 6 million installations worldwide. MySQL AB makes MySQL available as a free software license under the GNU General Public License (GPL), but they also sell under a commercial license for cases where their use does not match the use of the GPL.

Is not the same with projects such as Apache, where software developed by the general community, and the copyright to the source code owned by their respective authors, MySQL is owned and sponsored by a commercial company MySQL AB of Sweden, which holds the copyright on almost all the code source. Both the Swedish and one Finnish, which is founded MySQL AB: David Axmark, Allan Larsson, and Michael "Monty" Widenius.


MySQL is a relational Database Management System (RDBMS) that is distributed free under the GPL license (General Public License). Where every person is free to use MySQL, but is not a derivative of a closed-source or commercial. MySQL is a derivative one of the main concepts in the database since a long time, namely the SQL (Structured Query Language). SQL is a concept of operation of the database, especially for the election or selection and income data, which allows the operation of the data easily done automatically. The reliability of a database system (DBMS) can be known from the way it works in the Optimizer process SQL commands, which are made by users and application programs. As the database server, MySQL can be considered more superior than the other database servers in the data query. This proved to queries made by single users, the speed of MySQL queries can be ten times faster than PostgreSQL, and five times faster than the box. In addition, MySQL also has several distinctive, among others:

1. 1. Portability

MySQL can run on a variety of stable operating system like Windows, Linux, FreeBSD, Mac OS X Server, Solaris, Amiga, and many more.

1. 2. Open Source

MySQL is distributed open-source (free), under the GPL license so it can be used freely.

1. 3. Multi

MySQL can be used by several users at the same time without any problems or conflict.

1. 4. Performance Tuning

MySQL has a stunning speed in handling queries simple, in other words, can process more SQL per unit of time.

1. 5. Column types

MySQL has a type of column that is very complex, such as signed / unsigned integer, float, double, char, text, date, timestamps, and others.

1. 6. Command and Functions

MySQL functions and operators have the full support of the Select and Where in the query.

1. 7. Security

MySQL has several layers of securities such as the level of subnetmask, host name, and permits the user to access the licensing system and play the encrypted password.

1. 8. Scalability and Limits

MySQL database capable of handling large-scale, with the number of records of more than 50 million and 60 thousand table and 5 billion lines. In addition, the limit index that can be reached 32 index on each table.

1. 9. Connectivity

MySQL can connect with the client to use TCP / IP protocols, Unix socket (UNIX), or named pipes commands (NT).

1. 10. Localization

MySQL can detect the error message on the client by using more than twenty languages. Nevertheless, the language is not included therein.

1. 11. Interface

MySQL has the interface (interface) to various applications and programming languages using the API (Application Programming Interface).

1. 12. Clients and tools

MySQL is equipped with various tools that can be used for database administration, and on each tool that is included instructions online.

1. 13. The structure of the table

MySQL has a table structure that is more flexible in dealing with ALTER TABLE, compared to other databases such as PostgreSQL or Oracle.