MariaDB is a free, open-source and perhaps the most mainstream social information base framework all throughout the planet. It is a drop-in swap for MySQL data set framework. Notwithstanding, the construction and records of both information base frameworks are same, this will permit you to change your data set from MySQL to MariaDB without adjusting your applications.
As a matter of course, MariaDB is designed to tune in on localhost as it were. So it very well may be gotten to just from nearby clients working on a similar worker as the data set. In current web application engineering, most information base backends are facilitated on their own devoted worker. Perhaps the simplest approaches to accomplish this is to arrange the information base to permit far off associations.
In this post, We will bind IP Address with MariaDB on ubuntu 20.04 LTS
We believe, You have already installed MariaDB server on your ubuntu machine if not, So please go through given link to get installation process.
https://www.techbeginner.in/2019/12/how-to-install-mariadb-103-using-ubuntu_19.html
Step 1: Get IP Address
You need to get your system IP address and After that it will use with MariaDB server, Use the following command for the same.
ifconfig
Step 2: Open the MariaDB Config file
You need to open the MariaDB config file and add the following configuration to bind IP Address with MariaDB that will allow to make connectivity from the network.
sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
and update the bind parameter with your IP Address.
bind-address = IP_ADDRESS_HERE Save and exit from the text editor.
Step 3: Restart the Service
After this, You need to restart the MariaDB server to get new changes, Execute the given command.
sudo systemctl restart mysql
Step 4: Testing
You need to use the netstat command to verify the MariaDB port is bind with system IP Address or not, Use the following command.
netstat -plntu | grep 3306
Conclusion
We have successfully bind IP Address with MariaDB server on Ubuntu 20.04 server.