Xampp MySQL does not start - "Trying to start a MySQL service ..."

Question

I just installed XAMPP for Windows - there must be the latest version (XAMPP Control Panel v3.2.1).

Apache works fine on ports 80 and 443, but MySQL does not start. When I press the start button, I get this message:

Trying to start MySQL service ...

Then a window appears and asks me if I want to resolve this, what I want. But after that nothing happens. I can click as many times as I want, but with the same result.

What can I do with MySQL?

Answer 1

Change the MySQL port from 3306 to 3307 or something like that.

http://silentlyrun.blogspot.in/2013/02/how-to-change-apache-n-mysql-port-for.html

Hope this helps!

Answer 2

If you have already installed MySQL in your windows, go to the 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 port 3306.

Answer 3

I had a problem with this because I accidentally installed XAMPP in c:\windows\program files (x86) , which caused a problem with Windows permissions.

The installation says that it does not install it there, but I thought he said to install it there.

I uninstalled and reinstalled on c:\xampp and it worked.

Answer 4

Only stop My sql in Xampp in 15 minutes After 15 minutes, restart Mysql. If my sql works, but the port does not appear in Xampp, then click "Config"> my.ini edit this file and change the port 3306> 3307 and save and restart xampp .........

Answer 5

One of the many reasons is because xampp cannot start the MySQL service on its own. All you have to do is start the mySQL service manually.

First, make sure that " mysqld.exe " is not running, if it is, complete it. (go to Task Manager> Progress tab> right-click "mysqld.exe"> final task )

Open the services.msc service using Start (click Window + R)> services.msc or On the XAMPP control panel, click the Services button . Find " MySQL ", right-click and run it.

Answer 6

After Stop xampp go to setup and change port 3306 to 3308 mysql and save. Now run sql ...... Enjoy

Answer 7

There was this problem today, on a Windows 10 computer. I opened C:\xampp\data\mysql_error.log and looked for lines containing [ERROR] .

The last line of the error was:

 ... [ERROR] InnoDB: File (unknown): 'close' returned OS error 206. Cannot continue operation 

Important note : if your error is different, send it to Google (most likely you will find a fix).

In the search for the above error, I found this thread on the Apache Friends support forum, which led me to fix it:

1. Open C:\xampp\mysql\bin\my.ini and add the following line to the end of the [mysqld] section (above the line containing ## UTF 8 Settings ):

 innodb_flush_method=normal 

2. Restart the MySQL service. Should work just fine.

Answer 8

Did you use the default installation path?

In my case, when I started mysql_start.bat, I got the following error:

 Can`t find messagefile 'D:\xampp\mysql\share\errmsg.sys' 

I moved the xampp folder to the root of the disk and started working.

Hope this helps

Answer 9

1. In the cmd: services.msc Find MySql and change the properties to disabled.
2. In the Xampp control Xampp uninstall MySql using the checkbox on the left and install again by clicking on the same checkbox.

Answer 10

If you have other test applications, such as SQL Web Package, etc., uninstall them because they work on port 3306.

Answer 11

I can share how I solved the problem in my case.

Seems like I had MySQL Server 5.7 installed. It did not appear on the Add or Remove Programs list on Windows, so I did not know about it. I noted this after watching the XAMPP magazine.

Immediately after starting XAMPP, he showed in the log that there was a conflict in mySQL, and indicated the folder in which my MySQL Server 5.7 was installed. I manually deleted mySQL 5.7 from Program Files (x86) and the ProgramData folder, restarted it, and then XAMPP mySQL started normally.

I was only trying to stop the MySQL service, but for me this did not work. Only manually deleting all mySQL 5.7 folders seemed to help.

Answer 12

I have exactly the same problem. Finally found a solution:

The Relocate XAMPP option in the installer did not move the paths correctly and damaged them, but I manually changed the directories inside my.ini ( base dir , data dir , ...). After that, mysql started successfully.

Answer 13

Windows 10 users:

I also had this problem. A little investigation helped though. Prior to that, I had a problem that 3306 was used. So, I found out that port 3306 is used by another program. In particular, the JDBC program I was trying to learn, and I had xammp installed before I tried this JDBC. So, I deleted the whole file, and here I am, where you are. The problem was that my 'ImagePath' (registry variable) was changed after reinstalling mySql. Simply put, xammp no longer knows where your mysqld.exe is located, or the file is not in the place where you specified it. Here's how to fix it:

1. Open run (Win + r) and type "regedit". Here you can edit your registry.
2. Go to: HKEY_LOCAL_MACHINE> SYSTEM> CurrentControlSet> Services> MySql

3. Click on mySql and notice the ImagePath variable. Right-click ImagePath and click Modify.
4. Enter the location of your xammp mySqld file (locate it in xammp), although it probably matches 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

Answer 14

On Windows you should go: Start> Run> services.msc> Apache 2.4> Properties> Startup Mode> Automatic> Apply> Start> OK> [Same as MySQL]