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
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.
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.
When you see the XAMPP opened, you should see something like this. No red letters.
Do not mind about the Tomcat part. I currently don't need it.....
Hope it helps you...:-)