How to Resolve MySQL Port 3306 Error on Wamp

How to resolve mysql port 3306 error on wamp?

After so much exploring, it is rectified now. The my.ini file inside the Windows folder was the real problem. It is conflicting with the WAMP mysql my.ini. Now it is working fine after deleting that file from the Windows folder.

Mysql doesn't run on wamp, icon still orange

Thank you, people, I could solve the problem by uninstalling WAMP using iobit and clean the registry using Ccleaner, and then reinstall it and this time I choose English because my computer's language is English(last time I chose French. That what I did, don't know what's exactly solve it.

Why mysql is not working after port number of wamp is changed to 8080

Since the OSGEO installs a MYSQL Server instance as well as WAMPServer which uses the default port 3306, it gets conflicted with MYSQL Server of WAMPServer.

I changed the port that MYSQL should use in the WAMPServer my.ini file to 3307

port = 3307

and in php.ini changed

mysqli.default_port = 3307
mysql.default_port = 3307

According to @RiggsFolly, if using wampserver version 3.0.8+, use port 3308 instead

Can't start MySQL, port 3306 busy

In a command shell, run:

netstat -b -p TCP


netstat -an | grep -i listen | grep -E 3306

The first command will output a list that you will need to look through for the line that displays localhost:3306 in the second column. Below this is the application's name using the port.

The secondary command will find find the exact port you are looking for and looks something like this:

<example-name>:user <example-name>$ netstat -an | grep -i listen | grep -E 3306
tcp46 0 0 *.3306 *.* LISTEN

Port 3306 in use by C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file=C:\ProgramData\MySQL\MySQL..... error

After a couple times downloading and installing, and uninstalling the XAMPP three times while looking for answers (In the fourth time I downloaded and installed the XAMPP software, everything now works probably due to my prior troubleshooting efforts), I may now present to you how I was able to repair the error shown below.

"Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!"

The solution was to uninstall the three software indicated in the picture below.

enter image description here

I never used them...probably other people had downloaded it.

And perhaps my prior troubleshooting efforts I've done in the question probably helped to solved my problem.

Now, after you uninstalled those three pesky softwares, always start the XAMPP software in Administrator mode as shown below.

enter image description here

When you see the XAMPP opened, you should see something like this. No red letters.

enter image description here

Do not mind about the Tomcat part. I currently don't need it.....

Hope it helps you...:-)

Related Topics

Leave a reply