Xampp MySQL not starting - Attempting to start MySQL service

Question

I ve just installed XAMPP for Windows - should be the newest version  XAMPP Control Panel v3 2 1     Apache is running just fine on port 80 and 443  but MySQL is not starting  When I press the start button  I get this message      Attempting to start MySQL service      Then a window pops up and asks me if I want to allow this  which I want  But nothing happens after that  I can press as many times as I want  but with the same result   What can I do with MySQL

User · Answer

Windows 10 Users   I had this issue too   A little bit of investigating helped out though   I had a problem before this one  that 3306 was being used   So what I found out was that port 3306 was being used by another program   Specifically a JDBC program I was trying to learn and I had xammp installed before I tried this JDBC out   So I deleted the whole file and then here I am  where you re at   The issue was that my  ImagePath  registry variable  was changed upon installing mySql again  To put it simply  xammp doesn t know where your mysqld exe is at anymore  or the file is not in the location that you told it to be   Here s how to fix it    Open run  Win   r  and type  regedit    This is where you edit your registry  Navigate to  HKEY LOCAL MACHINE   SYSTEM   CurrentControlSet   Services   MySql      Click on mySql and notice the ImagePath variable   Right click  ImagePath  and click modify  Enter the location of your xammp mySqld file  navigate through xammp to find it  Although it is likely the same as mine    Cool Sources   https   superuser com questions 222238 how-to-change-path-to-executable-for-a-windows-service 252850   https   dev mysql com doc mysql-windows-excerpt 5 7 en mysql-installation-windows-path html  Thanks dave

User · Answer

if all solutions up did not work for you  make sure the service is running and not set to Disabled  Go to Services from Control panel and open Services  Search for Apache2 4 and mysql then switch it to enabled  in the column of status it should be switched to Running

User · Answer

Only for windows I have fixed the mysql startup issue by following below steps  Steps    Open CMD and copy paste the command netstat -ano   findstr 3306 If you get any result for command then the Port 3306 is active Now we want to kill the active port 3306   so now open powershell and paste the command  Stop-Process -Id  Get-NetTCPConnection -LocalPort 3306  OwningProcess -Force   Where 3306 is active port  Now port will be inactive   Start Mysql service from Xampp which will work fine now  Note  This works only if the port 3306 is in active state  If you didn t get any result from step 1 this method is not applicable  There could be some other errors  For other ports change 3306 to  Required port   Ways to open CMD and Powershell   For CMD-  search for cmd from start menu For Powershell-  search for powershell from start menu

User · Answer

Everytime my MySQL starts  it will stop  then I noticed that some files are getting generated in C  xampp mysql data  I tried deleting some files  like the Error logs  err file  etc   on that directory  Back up first what you re going to delete to avoid losing data    I don t know how it works  I m just trying to enable HTTPS in my local machine but then suddenly MySQL can t be started  But now it s working   I m using Windows 10 and XAMPP 3 2 4

User · Answer

After Stop xampp  go to configure and change the port 3306 to 3308 of mysql  and save  Now start the sql      Enjoy

User · Answer

If you have other testing applications like SQL web batch etc  uninstall them because they are running in port 3306

User · Answer

If you have MySQL already installed on your windows then go to services msc file on your windows and right click the MySQL file and stop the service  now open your XAMPP and start MySQL  Now MySQL will start on the port 3306

User · Answer

In the cmd type  services msc Find MySql and change properties to the disabled  In the control panel of Xampp uninstall MySql by the checkbox on the left side  and install again by the click in the same checkbox

User · Answer

I can share how I solved the problem in my case     It seems that somehow I had mySQL Server 5 7 installed  It didn t show on Add Remove Programs list in Windows tough so I wasn t aware of it  I marked that after I looked up the XAMPP log    Just after XAMPP launched it has shown in the log that there is a conflict in mySQL and indicated the folder where my mySQL Server 5 7 is installed  I removed mySQL 5 7 manually from Program Files  x86  and ProgramData folder  restarted and XAMPP mySQL started normally then     I ve tried only stopping the mySQL service but for me it didn t work  Only manually deleting all mySQL 5 7 folders seemed to have helped

User · Answer

I have the same problem  Finally found the solution    The Relocate XAMPP option in the setup tool didn t correctly relocate the paths and corrupted them  but I ve manually change the directories inside my ini  base dir  data dir         After that mysql started successfully

User · Answer

One of many reasons is xampp cannot start MySQL service by itself  Everything you need to do is run mySQL service manually   First  make sure that  mysqld exe  is not running  if have  end it   go to Task Manager   Progresses Tab   right click  mysqld exe    end task   Open your services msc by Run  press  Window   R     services msc or 0n your XAMPP ControlPanel  click  Services  button   Find  MySQL  service  right click and run it

User · Answer

Only stop My sql In Xampp For 15 Min After 15 min restart Mysql  If my sql running But Port Not Showing in Xampp then Click Config   my ini edit this file and change port no 3306   3307 and save and Restart xampp

User · Answer

I had an issue with this because I had accidentally installed XAMPP to c  windows program files  x86  which caused a Windows permissions issue   The installation says not to install it there  but I thought it had said to install it there   I uninstalled and reinstalled to c  xampp and it worked

User · Answer

Did you use the default installation path    In my case  when i ran mysql start bat I got the following error   Can t find messagefile  D  xampp mysql share errmsg sys    I moved my xampp folder to the root of the drive and it started working   Hope it helps

User · Answer

In Windows  you should go  Start   Run   services msc   Apache 2 4   Properties   Start Mode   Automatic   Apply   Start   OK    Same as MySQL

User · Answer

Had this problem today  on a Windows 10 machine  Opened C  xampp data mysql error log and looked for lines containing  ERROR    Last error line was         ERROR  InnoDB  File  unknown    close  returned OS error 206  Cannot continue operation   Important note  if your error is different  google it  you ll likely find a fix    Searching for the above error  found this thread on Apache Friends Support Forum  which led me to the fix    Open C  xampp mysql bin my ini and add the following line towards the end of  mysqld  section  above the line containing    UTF 8 Settings     innodb flush method normal    Restart MySQL service  Should run just fine

[mysql] Xampp MySQL not starting - "Attempting to start MySQL service..."

Examples related to mysql

Examples related to windows

Examples related to apache

Examples related to installation

Examples related to xampp