Mysql port already in use

Question

180718 12:43:04 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
180718 12:43:04 [ERROR] Do you already have another mysqld server running on port: 3306 ?
180718 12:43:04 [ERROR] Aborting

is there any solution for it? Mysql is running on windows based server. Please give the best solution..

Answer 1

Either a second instance of MySQL or another service is running on port 3306.

You can either stop the service which is running on port 3306 by

getting the process id of that service:

netstat -a -n -o | find "3306"

and then killing that process (e.g. for process id 1234):

taskkill /pid 1234 /f

or run MySQL on a different port.