Client-Server refers to an architecture in which two or more computers are connected together over a network to send and receive requests between one another.
In their communication, each machine has its own role: the machine sending requests is usually referred as "Client" and the machine responding (serving) is called "Server".
In this case, our Web Server has a role of a "Client" that connects and reads/writes to/from a Database (DB) Server (MySQL, MongoDB, Oracle, SQL Server or any other), and the communication between them happens over a Local Network (it can also be Internet connection, but it is a common practice to place Web Server and DB Server close to each other in local network).
In this tutorial I would be demonstrating a basic client-server using MySQL Relational Database Management System (RDBMS), follow the below instructions
Create and configure two Linux-based virtual servers (EC2 instances in AWS) with names.
Server A name - `mysql server` Server B name - `mysql client`
On mysql server Linux Server install MySQL Server software.
sudo apt install mysql-server
On mysql client Linux Server install MySQL Client software.
sudo apt install mysql-client
By default, both of your EC2 virtual servers are located in the same local virtual network, so they can communicate to each other using local IP addresses. Use mysql server's local IP address to connect from mysql client. MySQL server uses TCP port 3306 by default, so you will have to open it by creating a new entry in ‘Inbound rules’ in ‘mysql server’ Security Groups. For extra security, do not allow all IP addresses to reach your ‘mysql server’ – allow access only to the specific local IP address of your ‘mysql client’.
You might need to configure MySQL server to allow connections from remote hosts.
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
and replace the following line:
bind-address = 127.0.0.1
with the following line:
bind-address = 0.0.0.0
In your mysql-server ec2 instance allow the ipaddress of the mysql-client ec2 instance with port 3306 to access the mysql-server ec2 instance.
On your mysql-server create a new user using the following code
CREATE USER 'newuser2'@'22.214.171.124' IDENTIFIED BY 'password2'; GRANT ALL PRIVILEGES ON * . * TO 'newuser2'@'126.96.36.199';
To connect to the mysql server, in your mysql client enter the following code.
mysql -u newuser2 -h 188.8.131.52 -p
Note: The format is
mysql -u <user> -h <ipaddress-of-the-server> -p
and run the following