in xampp port 3306 automatically giving an error whenever I try to open it.

Question

11:30:16  [main] Initializing Control Panel

11:30:16  [main] Windows Version:  Home  64-bit

11:30:16  [main] XAMPP Version: 8.0.2

11:30:16  [main] Control Panel Version: 3.2.4  [ Compiled: Jun 5th 2019 ]

11:30:16  [main] You are not running with administrator rights! This will work for

11:30:16  [main] most application stuff but whenever you do something with services

11:30:16  [main] there will be a security dialogue or things will break! So think

11:30:16  [main] about running this application with administrator rights!

11:30:16  [main] XAMPP Installation Directory: "c:\xampp"

11:30:16  [main] Checking for prerequisites

11:30:17  [main] All prerequisites found

11:30:17  [main] Initializing Modules

11:30:17  [main] Starting Check-Timer

11:30:17  [main] Control Panel Ready

11:30:25  [mysql] Attempting to start MySQL app...

11:30:25  [mysql] Status change detected: running

11:30:27  [mysql] Status change detected: stopped

11:30:27  [mysql] Error: MySQL shutdown unexpectedly.

11:30:27  [mysql] This may be due to a blocked port, missing dependencies,

11:30:27  [mysql] improper privileges, a crash, or a shutdown by another method.

11:30:27  [mysql] Press the Logs button to view error logs and check

11:30:27  [mysql] the Windows Event Viewer for more clues

11:30:27  [mysql] If you need more help, copy and post this

11:30:27  [mysql] entire log window on the forums

11:31:22  [Apache] Attempting to start Apache app...

11:31:22  [Apache] Status change detected: running

11:31:26  [mysql] Attempting to start MySQL app...

11:31:26  [mysql] Status change detected: running

11:31:28  [mysql] Status change detected: stopped

11:31:28  [mysql] Error: MySQL shutdown unexpectedly.

11:31:28  [mysql] This may be due to a blocked port, missing dependencies,

11:31:28  [mysql] improper privileges, a crash, or a shutdown by another method.

11:31:28  [mysql] Press the Logs button to view error logs and check

11:31:28  [mysql] the Windows Event Viewer for more clues

11:31:28  [mysql] If you need more help, copy and post this

11:31:28  [mysql] entire log window on the forums

11:31:38  [mysql] Attempting to start MySQL app...

11:31:38  [mysql] Status change detected: running

11:31:40  [mysql] Status change detected: stopped

11:31:40  [mysql] Error: MySQL shutdown unexpectedly.

11:31:40  [mysql] This may be due to a blocked port, missing dependencies,

11:31:40  [mysql] improper privileges, a crash, or a shutdown by another method.

11:31:40  [mysql] Press the Logs button to view error logs and check

11:31:40  [mysql] the Windows Event Viewer for more clues

11:31:40  [mysql] If you need more help, copy and post this

11:31:40  [mysql] entire log window on the forums

this is the error I've got. I truned off my defender as well. but still I could not open the port

Answer 1

Hi AkilaSiriwardane,

This may be because the 3306 port is blocked by a firewall.

You can try adding a Port or Program exception to Windows Firewall Defender as follows:

To add a "Port Exception":

Go to Start -> Run and type firewall.cpl.

    In the left-hand list, Click on the “Advanced Settings” link.

    The Windows Firewall with Advanced Security Window opens.

    Click on the “Inbound Rules” option.

    In the left pane, click on “New rule”.

    Under “Rule Type” select the option “Port”, and click next.

    Select “TCP”and “specific local ports” options.

    Key in an appropriate (non-conflicting) port number.

    The default port for MySQL is 3306, Apache is 80, and Skype is 443. You'll need to choose something different.

    Click Next.

    Select the option “Allow the connection”.

    Click Next, do not change any option here and click Next again.

    Specify a name for this rule, and, if you wish, a description.

    Click Finish.

Regards,

Navaz Khan

Answer 2

Hi Akila

I am Dave, an Independent Advisor, I will help you with this . . .

Port 3306 is a commonly used port by software like Skype, Zoom . . etc, usually when installing XAMPP, the best option is to change the port used by that server

You can find more information on that over on the Apache Forum, that is the best place to look for info on XAMPP and MySQL . . .

https://community.apachefriends.org/f/viewtopic....

________________________________________________________

Standard Disclaimer: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

.