How to Change Default MariaDB/MySQL Port in Linux


 

In this post,  We will figure out how to change the default port that MySQL/MariaDB information base ties in CentOS 7 and Debian-based Linux machine. The default port that MySQL data set worker is running under Linux and Unix is 3306/TCP.

 

We believe, You have already installed and running Mysql/MariaDB Server on ubuntu 20.04 LTS.If not you can click on given link to install MySQL/MariaDB on ubuntu.

 

https://www.techbeginner.in/2019/12/how-to-install-mariadb-103-using-ubuntu_19.html

 

Step 1: Open the Default Config file

 

The default port that the MySQL data set worker runs under Linux is 3306/TCP. Utilize the orders underneath to change the default MySQL/MariaDB Database port in Linux.

sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf

 

[mysqld]  
port = 3306

Chnage to

[mysqld]  
port = 3307

Here we have change the port number to 3306 to 3307 under the [mysqld].

 

Step 2: Restart the Mysql/MariaDB Server

 

To get new changes in MariaDB/Mysql Server, We need to restart the service, Use the given command for the same.

sudo systemctl restart mysql

 

Step 3: Verify the Port Number

 

You need to verify the port number by using the netstat, Execute the given command.

netstat -plntu | grep 3307

 

Step 4: Login with MariaDB/Mysql Shell 

 

We are ready to use the new port number with MariaDB/Mysql by using the given command.

mysql -h localhost -P 3307 -u root -p

 

 

Conclusion

We have successfully change the default port number with MariaDB server on Ubuntu 20.04 server.


How to Change Default MariaDB/MySQL Port in Linux

Leave a Reply

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

Scroll to top