MySQL is the most famous relational database management system in the world, given that it is available under an open source GUN GPL license. MySQL is designed around three main concepts: stability, speed, and ease of use.
MySQL features
The most important features of MySQL database systems are speed and stability, something that explains the many usage by developers, managers and users around the world, and we will now review what distinguishes this database in some detail.
MySQL speed
One of the most important features of a MySQL relational database management system is the time it takes to execute a query and return the results to the user. This is due to the fact that MySQL uses a multi-tasking structure such as indexing and nodes, and queries hidden in memory, something that resulted in high performance without the need for any custom programming from By the user.
Security in MySQL
Security is one of the strong points in MySQL. It comes with a complex access control system and an authorization system to prevent unauthorized users from accessing the database. This system is implemented in the form of five layers of authorities in a hierarchical manner, which enables MySQL administrators to protect access to sensitive data. Limit users to perform operations on specific databases or only specific fields, MySQL also allows control over the types of queries that a user can run at the database, table or field level.
Ease of use MySQL
Ease of use is one of the important points that MySQL focused on. The MySQL development team took the task of facilitating the use, management and improvement of MySQL performance. The main interface of the MySQL server is a simple line interface, which consists of two graphical interfaces, namely MySQL Control Center and MySQL. Administrator, which was developed by MySQL AB to use and manage MySQL.
Support various programming languages
MySQL provides a programming interface for various programming languages to enable you to write database applications in the language of your choice. It supports PHP, Java, c ++, Perl, Python, Tcl and others to give developers maximum freedom in designing applications based on MySQL.
“Source : Link”
