Solution to IDEA not being able to connect to MySQL port number occupation

I can log in to MYSQL normally under the command line, and navicat can connect to MySQL normally, but IDEA cannot connect to MySQL. Emmm, what's going on. . .

Look at the error message:

I always thought it was a problem with the MySQL password or access rights.

Troubled for n days. . .
One day, I suddenly remembered that port number 3306 was occupied. I was also puzzled, but after checking the port number, I found that port number 3306 was actually in use by two port numbers. . .
ps: View the command for port number usage: netstat -ano
Command to disable the process: taskkill -PID <process number> -F
Could the problem be here? Try to disable one of the processes according to the PID.

Then go to IDEA to connect to MySQL
I found that life is full of surprises and it was successful.

However, there is also confusion <br /> Why are there two processes using 3306? ? ?
And, after disabling one of them, IDEA can connect. I hope the big guys can answer this question.

This is the end of this article about how to solve the problem that IDEA cannot connect to MySQL port number occupation. For more information about IDEA MySQL port number occupation, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!