How To Check MySQL Port And Connection Status?

Using netstat Command

The netstat command checks network connections and port status. To verify the MySQL port using netstat:

1. Open a terminal or command prompt.
2. Type this command:

netstat -tln | grep 3306

This command shows only the MySQL default port (3306). If MySQL is running on this port, you'll see output like:

tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN

This output shows that MySQL is listening on port 3306 on the localhost (127.0.0.1).

netstat -tln | grep <your-mysql-port>

Using lsof Command

The lsof (List Open Files) command also checks port usage. To use lsof to verify the MySQL port:

1. Open a terminal or command prompt.
2. Enter this command:

sudo lsof -i :3306

If MySQL is running on port 3306, you'll see output like:

COMMAND   PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
mysqld  12345 mysql   46u  IPv6 123456      0t0  TCP *:mysql (LISTEN)

This output shows the process ID (PID) of MySQL, the user running the process, and confirms that it's listening on the MySQL port (3306).

Both netstat and lsof commands give information about MySQL's port status, helping you verify that the server is running on the expected port.

MySQL Command Line Client

To connect to MySQL using the command line:

1. Open a terminal or command prompt.
2. Use this command:

mysql -u username -p -h hostname

Replace "username" with your MySQL username and "hostname" with your server's address (use "localhost" for a local server).

If the connection works, you'll see the MySQL prompt. If you have problems:

1. Check your username and password.
2. Make sure the MySQL service is running.
3. Check if the hostname and port are correct.
4. Look at firewall settings that might block the connection.

SHOW STATUS;

Using MySQL Workbench

MySQL Workbench offers a visual interface for database management. To connect:

1. Open MySQL Workbench.
2. Click on "New Connection" or "+" icon.
3. Enter the connection details:
   • Connection Name
   • Hostname
   • Port
   • Username
4. Click "Test Connection" to check.

If the connection works, you'll see a confirmation message. If not, MySQL Workbench will show an error message to help you fix the issue.

To check the connection status in MySQL Workbench:

1. Open the connection.
2. Look at the status bar at the bottom of the window.
3. It should show "Connected" and the server version.

These methods help you check and fix MySQL connection status, making database management easier.