How to Bind MariaDB server with IP address on ubuntu 20.04 LTS


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.


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.



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


We have successfully bind IP Address with MariaDB server on Ubuntu 20.04 server.


How to Bind MariaDB server with IP address on ubuntu 20.04 LTS

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top