What exactly is MySQL

• MySQL is an open source relational database management system (RDBMS) with a client-server model
• RDBMS is a software used to manage databases based on a relational model MySQL is a Web-based database system
• MySQL is a servered database system 
• MySQL is ideal for large as well as small applications 
• MySQL is very fast, stable and user friendly 
• MySQL makes standard use of SQL 
• MySQL compiles multiple platforms 
• MySQL can be downloaded and used gratis 
• MySQL is developed and distributed by Oracle Corporation and is supported 
• The data is stored in tables within a MySQL database. A table consists of columns and rows and is a collection of related data.

Database

• A database is a collection of a structured data
• A database is a place where it stores data and organize it
• The word ‘relational’ means that data stored in the data set is organized in tables

Open Source

• Open source is a source that are free to be used and modified
• However the GPL (GNU Public License) determines what you can do depending on the conditions

Client-server model

• Computers that install and run RDBMS are called clients
• They link to the RDBMS server whenever they need to access data
• This is the part they are called ‘client-server’ part

SQL

• MySQL and SQL are not similar
• MySQL is a RDBMS software which implements a client-server model
• The client-server model communicate in a RDBMS environment by using domain-speicific language- SQL ( Structured Query Language)
• SQL instructs the server on what to do with the data (similar to the to WordPress code)
• Input it to the system to gain access to the dashboard area
• SQL statements can operate the server to perform certain operations

What does SQL do?

• Data query: requesting specific information from the existing database.
• Manualisation of data: adding, deleting, changing, sorting, and other operations to modify the data, the values or the visuals.
• Data identity: defining types of data , for example changing numerical data to integer. This also includes the definition of a scheme or the relation of each table in the database
• Data access control: providing security techniques to protect data, this includes deciding who can view or use any information stored in the database

How is MySQL working?

The picture illustrates the :

• client-server system foundation system. 
• One or more computers (clients) connect to a server over a specific network. 
• On their screens, each client will make a request from the graphical user interface (GUI) and the server will generate the requested output, as long as both ends understand the instruction. 
• The main processes occurring in a MySQL environment are the same without becoming too technical, which are:

1. MySQL provides a database to store and manipulate data, to establish the relationship between each table. 
2. By typing specific SQL statements into MySQL, clients can make requests. 
3. The server application will respond with the information requested, and will appear on the side of the clients.

Why does MySQL get so popular?

• Efficient and user friendly ; You can change the source code to suit your own standards, and you don’t have to pay for that degree of flexibility, including the upgrade options to the advanced commercial version. The installation process is fairly simple, and does not take longer than 30 minutes.
• Strong ratings ; A wide variety of cluster servers will back up MySQL. Whether you’re storing massive amounts of large e-commerce data or doing heavy business intelligence, MySQL can help you with optimum speed. 
• Branch norm Industries have been using MySQL for years ,meaning skilled developers have plenty of resources. MySQL users should expect fast app creation and freelance experts willing to work for a lower wage should they ever need it. 
• Safely assume ; When selecting the right RDBMS program the data should be the primary concern. MySQL sets the security bar to high with its Access Privilege System and User Account Management.