Unable to connect to localhost:3306 (2003) for MySQL 8.0.21 on Windows

Question

I am using MySQL workbench to connect to my local server. Everything was running fine and suddenly I jumped in a connection refused errors. I tried restarting the server again and again. Clearing temp files and also restarted my machine. I found this post from which I tried a couple of things like net stop and stopping the process from the services list but in the services list it shows as below:

I waited like for 30 mins but still, the service is not stopped.
Also, below is the screenshot for MySQL workbench when I try to start the server:

Is there anything specific which I need to do in order to resolve this error:

you have to check the mysql error log, which will tell you what is wrong — nbk, Jul 26 '20 at 16:03
Try changing the `MySQL service` to manual instead of automatic. Also see if there is a `mysql process` still running in the `Windows Task Manager` and if so, try to kill that. — Fullslack, Jul 26 '20 at 16:05
"Is there anything specific which I need to do in order to resolve this error" yes, you need to Debug ... — Luuk, Jul 26 '20 at 16:14
Click on `MANAGEMENT->Server Status` Check the port number that MySQL is listening on — RiggsFolly, Jul 26 '20 at 16:46
I checked the port number and it's 3306 which comes by default — whatsinthename, Jul 26 '20 at 19:53
I changed `MySQL service` to manual and refreshed but still didn't work. — whatsinthename, Jul 26 '20 at 19:54

score 0 · Accepted Answer · answered Jul 26 '20 at 20:28

So, I resolved my own problem in this way. I referred the documentation for this particular error and for my error which is of 2003 type it said that look for mysqld.exe process in task manager and if you don't find any then start the server. But, in my case I found 2 mysqld.exe processes running. So, I killed those processes and restarted the server. It worked!!

Might help someone someday :)

Unable to connect to localhost:3306 (2003) for MySQL 8.0.21 on Windows

1 Answers1