Thursday, August 8, 2013

Port 3306 in use by "mysqld.exe"! || MySQL XAMPP is giving error || MySQL XAMPP is not getting restarted.

Port 3306 in use by "mysqld.exe"! || MySQL XAMPP is giving error || MySQL XAMPP  is not getting restarted.
Port 3306 in use by "mysqld.exe"!
What to do if you get the “Port 3306 in use by "mysqld.exe"!” error on starting up the XAMPP control panel?
Port 3306 in use by "mysqld.exe"!||Port 3306 in use by "mysqld.exe"!
8:53:08 AM  [mysql]      Problem detected!
8:53:08 AM  [mysql]      Port 3306 in use by "mysqld.exe"!
8:53:08 AM  [mysql]      MySQL WILL NOT start without the configured ports free!
8:53:08 AM  [mysql]      You need to uninstall/disable/reconfigure the blocking application
8:53:08 AM  [mysql]      or reconfigure MySQL to listen on a different port


port 3306 in use by mysqld.exe
port 3306 in use by mysqld.exe
  1. Go to Run prompt i.e. Start>>Run or Search Programs and Files edit box.
  2. Type “Services.msc” over there and press enter key.
  3. Search for “MySQL56” service.
  4. Check if the Service is showing Status as “Started”.
  5. Right click over there i.e. on service itself.
  6. Click on Stop and let the service be stopped.
  7. Go to XAMPP control panel and click on Quit button.
  8. Open the xampp-control
  9. Problem is solved for "Port 3306 in use by "mysqld.exe"!" and you will see the following message.

1:36:24 PM  [main]        Initializing Control Panel
1:36:24 PM  [main]        Windows Version: Windows 7 Professional  64-bit
1:36:24 PM  [main]        XAMPP Version: 1.8.1
1:36:24 PM  [main]        Control Panel Version: 3.1.0 3.1.0 [ Compiled: September 20th 2012 ]
1:36:24 PM  [main]        Running with Administrator rights - good!
1:36:24 PM  [main]        XAMPP Installation Directory: "c:\xampp\"
1:36:24 PM  [main]        Checking for prerequisites
1:36:25 PM  [main]        All prerequisites found
1:36:25 PM  [main]        Initializing Modules
1:36:25 PM  [main]        Starting Check-Timer
1:36:25 PM  [main]        Control Panel Ready

Port 3306 in use by "mysqld.exe"!

3 comments:

  1. Great Post on Port 3306 in use by mysqld.exe. This really worked for me.-Nathen

    ReplyDelete
  2. 100000s of Thanks to you ! Problem resolved after scratching my head for a long time.
    God Bless You sir

    ReplyDelete
  3. whenever i try to start mysql on xampp..the sql (on service) gets started and i get the same error as before.

    ReplyDelete