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
or
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...:-)
Related Topics
Php - Mysqli_Fetch_Array() Expects Parameter 1 to Be Mysqli_Result, String Given
How to Convert a 13 Digit Unix Timestamp to Date and Time
Laravel How to Return Single Column Value Using Query Builder
How to Delete Multiple Redis Keys With the Same Pattern in PHP Using Phpredis
Codeigniter - Show Information in Modal Window
How to Add Whatsapp Share Button to PHP Website
Laravel Eloquent Sum of Multiplied Columns
Dynamic Menu and Role Permission in Codeigniter
How to Find Out If CSV File Fields Are Tab Delimited or Comma Delimited
How to Change PHP Version in Xampp
Convert Svg Image to Png With PHP
Php Json String, Escape Double Quotes for Js Output
How to Enable the Mysqli Extension in PHP 7
How to Convert Text to Svg Paths