Course Content
MySQL Editions
MySQL Editions
0/1
MySQL Database Structure
MySQL Database Structure
0/1
MySQL Components
MySQL Components
0/1
MySQL Tools
MySQL Tools
0/1
MySQL Data Types
MySQL Data Types
0/1
MySQL Storage Engines
MySQL Storage Engines
0/1
Create MySQL Database
Create MySQL Database
0/1
MySQL Create Table
MySQL Create Table
0/1
MySQL INSERT Statement
MySQL INSERT Statement
0/1
MySQL SELECT Statement
MySQL SELECT Statement
0/1
MySQL UPDATE Statement
MySQL UPDATE Statement
0/1
MySQL DELETE Statement
MySQL DELETE Statement
0/1
MySQL DROP Database
MySQL DROP Database
0/1
MySQL Functions
MySQL Functions
0/1
MySQL CREATE VIEW
MySQL CREATE VIEW
0/1
MySQL DROP Table
MySQL DROP Table
0/1
MySQL GROUP BY Clause
MySQL GROUP BY Clause
0/1
MySQL Replace Statement
MySQL Replace Statement
0/1
MySQL Subquery
MySQL Subquery
0/1
MySQL Joins
MySQL Joins
0/1
MySQL Import/Export
MySQL Import/Export
0/2
MySQL Beginner
About Lesson

MySQL Architecture

MySQL RDBMS operates as a client/server architecture model. The key components in the model are as follows:

  • MySQL Server
  • MySQL Client

 

 

MySQL Tutorials for Beginners

 

 

MySQL Server

MySQL server is the central software program that manages the database objects, data, etc. The MySQL Server(mysqld) listens on a specific network port for incoming connection requests from clients. Clients can connect to the server to access or modify data in the database. The default port of the MySQL Server is 3306.

On the Windows operating system, we can know the MySQL server version by the following command:

Change working directory to MYSQL HOMEbin directory.

> mysqld –version

MySQL Architecture Server

 

MySQL Client

MySQL clients are applications that sends requests to the database server. MySQL clients are software applications that connect to the server to access and manipulate the data in the database. In order for the clients to access data, the MySQL server must be running.

The client connects to the server, sends requests to the server. The server handles the requests and processes the requests. The client receives the response and disconnects from the server. MySQL Server can handle multiple database client connections at once.

MySQL clients can be

  • Local – local clients run on the same machine where the MySQL Server runs.
  • Remote – remote clients run on a different remote machine.

Remote clients connect to the MySQL Server using the TCP/IP network communication protocol. Local connections can use shared pipe, socket file(Unix) or TCP/IP.