How To Change MySQL Port Number On Linux Debian 11.3
To Change MySQL Port Number On Linux Debian 11.3
Introduction:
MySQL is an open-source relational database management system. For WordPress sites, that means it helps you store all your blog posts, users, plugin information and etc.
Installation Procedure:
Step 1: To check the OS version by using the following command
root@linuxhelp: ~# lsb_release -a
Step 2: Getting into the MySQL shell by using the below command
root@linuxhelp:~# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.28-0ubuntu0.20.04.3 (Ubuntu)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Step 3: Check the port number by using the below command
mysql> select @@port;
+--------+
| @@port |
+--------+
| 3306 |
+--------+
1 row in set (0.00 sec)
Step 4: Quit the MySQL shell by using the below command
mysql> \q
Bye
Step 5: Enter into the Configuration directory by using the below command
root@linuxhelp:~# cd /etc/mysql/mysql.conf.d/
Step 6: List the files by using the below command
root@linuxhelp:/etc/mysql/mysql.conf.d# ls -la
total 20
drwxr-xr-x 2 root root 4096 Feb 22 03:47 .
drwxr-xr-x 4 root root 4096 Feb 22 01:29 ..
-rw-r--r-- 1 root root 132 Feb 22 00:59 mysql.cnf
-rw-r--r-- 1 root root 2220 Feb 22 03:47 mysqld.cnf
-rw-r--r-- 1 root root 2219 Feb 22 01:29 mysqld.cnf.save
Step 7: Edit the mysqld.cnf Configuraion file by using the below command
root@linuxhelp:/etc/mysql/mysql.conf.d# nano mysqld.cnf
#The MySQL database server configuration file.
#One can use all long options that the program supports.
#Run program with --help to get a list of available options and with
#--print-defaults to see which it would actually understand and use.
#For explanations see
#http://dev.mysql.com/doc/mysql/en/server-system-variables.html
#Here is entries for some specific programs
#The following values assume you have at least 32M ram
[mysqld]#
#*Basic Settings#
#pid-file = /var/run/mysqld/mysqld.pid
#socket = /var/run/mysqld/mysqld.sock
user = mysql
port = 3344
Step 8: Restart the MySQL service by using the below command
root@linuxhelp:/etc/mysql/mysql.conf.d# systemctl restart mysql.service
Step 9: Enter into the MySQL shell by using the below command
root@linuxhelp:/etc/mysql/mysql.conf.d# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.28-0ubuntu0.20.04.3 (Ubuntu)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Step 10: Check the port number by using the below command
mysql> select @@port;
+--------+
| @@port |
+--------+
| 3344 |
+--------+
1 row in set (0.00 sec)
mysql> \q
Bye
Step 11: Edit the Configuration file by using the below command
root@linuxhelp:/etc/mysql/mysql.conf.d# nano mysqld.cnf
Step 12: Restart the MySQL service by using the below command
root@linuxhelp:/etc/mysql/mysql.conf.d# systemctl restart mysql.service
root@linuxhelp:/etc/mysql/mysql.conf.d# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Step 13: Check the port by using the below command
mysql> select @@port;
+--------+
| @@port |
+--------+
| 3306 |
+--------+
1 row in set (0.00 sec)
Conclusion:
We have reached the end of this article. In this guide, we have walked you through the steps required to change MySQL Port number On Linux Debian 11.3.Your feedback is much welcome.