[Solved] Another mysqld server running on port: 3306

MySQL service may start throwing errors as below while starting/restarting the MySQL service on a Linux server

[ERROR] Can't start server: Bind on TCP/IP port: Address already in use

[ERROR] Do you already have another mysqld server running on port: 3306 ?

[ERROR] Aborting

Looking at the error, it seems to be an issue with the MySQL port 3306.

Solution 1:

Check if MySQL service is stopped, if not stop the service

/etc/init.d/mysqld status

Check if MySQL service port 3306 is still in use or not

netstat -apn | grep 3306

If port is still in use then kill the process using the port 3306

kill -9 pid

Start the MySQL service.

/etc/init.d/mysqld start

Solution 2:

Check the bind address in the MySQL configuration file /etc/my.cnf
Set is as per the requirement (mostly localhost / 127.0.0.1) or you may comment the bind-address field.

Start the MySQL service

/etc/init.d/mysqld start

Hope this helps!

Share on Facebook3
Share on Google+3Tweet about this on TwitterShare on StumbleUpon0Share on LinkedIn2Share on Tumblr0Digg thisPin on Pinterest0Share on Reddit0Email this to someonePrint this page
MySQL service may start throwing errors as below while starting/restarting the MySQL service on a Linux server [ERROR] Can't start server: Bind on TCP/IP port: Address already in use [ERROR] Do you already have another mysqld server running on port: 3306 ? [ERROR] Aborting Looking at the error, it seems to be an issue with the MySQL port 3306. Solution 1: Check if MySQL service is stopped, if not stop the service /etc/init.d/mysqld status Check if MySQL service port 3306 is still in use or not netstat -apn | grep 3306 If port is still in use then kill the…

Review Overview

User Rating: Be the first one !

About Abhijit Sandhan

Abhijit Sandhan
Loves Linux, Blogging, Traveling, Hiking and sharing knowledge!

Leave a Reply

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

CAPTCHA