How to Check MySQL Listening Port

Table of Contents

1. Understanding MySQL Default Port
2. Checking MySQL Port Using Command Line
3. Finding Port Information in MySQL Configuration Files
4. Using SQL Commands to Retrieve Port Number
5. Checking Active Ports with Networking Tools
6. Tips for Efficient Port Checking
7. Conclusion

---

1. Understanding MySQL Default Port

By default, MySQL listens on port 3306 for TCP/IP connections. However, this port can be modified during installation or afterward for security purposes or to accommodate multiple MySQL instances on the same server.

Why Might the Port Change?

• Security: Changing the default port can help obscure the service from automated attacks targeting standard ports.
• Multiple Instances: Running more than one MySQL server on the same machine requires assigning different ports to each instance.

2. Checking MySQL Port Using Command Line

The command line is one of the quickest ways to check the MySQL listening port.

Step 1: Access the Terminal

Open your terminal or command prompt.

Step 2: Use the netstat Command

For Linux or macOS:

sudo netstat -plnt | grep mysqldCopy

For Windows (Command Prompt):

netstat -ano | findstr "3306"Copy

Explanation:

• netstat -plnt: Lists all listening ports with the associated program names.
• grep mysqld: Filters the results to show only MySQL-related entries.

Sample Output:

The output shows that MySQL is listening on port 3306.

3. Finding Port Information in MySQL Configuration Files

The MySQL configuration file contains settings defining the server’s operation, including the listening port.

Step 1: Locate the Configuration File

• Linux: Typically located at /etc/my.cnf or /etc/mysql/my.cnf.
• Windows: Look for my.ini in the MySQL installation directory.

Step 2: Open the Configuration File

Use a text editor to open the file. For example:

sudo nano /etc/mysql/my.cnfCopy

Step 3: Search for the Port Setting

Look for the [mysqld] section and find the port variable.

[mysqld]
port=3306Copy

If the port line is commented out or absent, MySQL uses the default port 3306.

4. Using SQL Commands to Retrieve Port Number

You can query the MySQL server to find out which port it is using.

Step 1: Log into MySQL

mysql -u root -pCopy

Step 2: Run the Query

SHOW GLOBAL VARIABLES LIKE 'port';Copy

Sample Output:

Step 3: Exit MySQL

EXIT;Copy

5. Checking Active Ports with Networking Tools

Use networking tools like ss or lsof for more detailed information.

Using ss Command (Linux)

sudo ss -tulpn | grep mysqldCopy

Using lsof Command

sudo lsof -i -P -n | grep LISTEN | grep mysqldCopy

These commands list open network sockets and filter the results to show MySQL-related entries.

6. Tips for Efficient Port Checking

Automate with Scripts

Create a simple script to check the MySQL port quickly:

#!/bin/bash
PORT=$(mysql -u root -pYOURPASSWORD -e "SHOW GLOBAL VARIABLES LIKE 'port';" | grep 'port' | awk '{print $2}')
echo "MySQL is listening on port: $PORT"Copy

Note: Replace YOURPASSWORD with your actual password or better yet, use a .my.cnf file for credentials.

Use Aliases for Frequent Commands

Add aliases to your shell configuration (~/.bashrc or ~/.zshrc):

alias mysqlport="mysql -u root -p -e \"SHOW GLOBAL VARIABLES LIKE 'port';\""Copy

Reload the shell:

source ~/.bashrcCopy

Now, simply type mysqlport to check the port.

Secure Your MySQL Instance

• Firewall Rules: Ensure your firewall allows traffic on the MySQL port if remote connections are necessary.
• Bind Address: Set bind-address in the MySQL configuration to control which interfaces MySQL listens on. [mysqld] bind-address=127.0.0.1

Monitor Port Usage

Regularly monitor port usage to detect unauthorized changes:

sudo netstat -tulpn | grep LISTENCopy

7. Conclusion

Knowing how to check the MySQL listening port is essential for database administration, security, and troubleshooting. Whether you prefer using command-line tools, querying the database directly, or inspecting configuration files, this guide provides multiple methods to find the information you need efficiently.

Remember: Always secure your MySQL server by keeping ports properly configured and monitored.