CODEWITHSUNDEEP
mysqlampps
SangyK
SangyK

Reputation: 839

MySQL not Starting in AMPPS

I have installed AMPPS in my windows 10(64 bit) local machine. When Starting, Apache and PHP have started but MySQL is not starting.

I tried some solutions from this page

But nothing seems to work.

Upvotes: 4

Views: 26769

Answers (7)

Lalarukh khan
Lalarukh khan

Reputation: 170

After various tries, I just clicked on "restore default configuration" and i made it again to work.

enter image description here

Upvotes: 0

Richard Apuliba
Richard Apuliba

Reputation: 1

  • Search for [mysqld] section.
  • Add following line below [mysqld] section:
innodb_force_recovery = 1
  • Save configuration and restart MySQL.
  • Now Stop MySQL.
  • Remove the line just added and start MySQL again.

Upvotes: 0

bhushan deshmukh
bhushan deshmukh

Reputation: 75

i deleted these two files mysql.sock.lock,mysqlx.sock.lock under var folder and it worked

Upvotes: 5

Udara Herath
Udara Herath

Reputation: 885

open Ampps/mysql/data/ folder and delete all files similar to this ib_logfile and mysql-bin,ibdata, etc then start or restart MySQL via the AMPPS.

Upvotes: 1

SamQuay
SamQuay

Reputation: 59

This works!!!

Install Visual C++ 2010 Runtime, both 32bit and 64bit versions, from url:

32Bit: Microsoft Visual C++ 2010 SP1 Redistributable Package (x86) http://www.microsoft.com/en-us/download/details.aspx?id=8328

64Bit: Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) http://www.microsoft.com/en-us/download/details.aspx?id=13523

Upvotes: 5

Wojciech A.
Wojciech A.

Reputation: 174

I have the same problem and the solution with innodb_force_recovery = 1 didn't work. When I run /ampps/mysql/bin/mysql.exe it was written that MSVCR100.dll was missing. I solve that by installing Visual C++ 2010 Runtime, both 32bit and 64bit versions, from url:

32Bit: Microsoft Visual C++ 2010 SP1 Redistributable Package (x86)
http://www.microsoft.com/en-us/download/details.aspx?id=8328

64Bit: Microsoft Visual C++ 2010 SP1 Redistributable Package (x64)
http://www.microsoft.com/en-us/download/details.aspx?id=13523

This works for me and mysql start working :)

Upvotes: 13

Lukáš Stříbrný
Lukáš Stříbrný

Reputation: 1

i was having the same issue but no solution from internet worked,
most of the people suggesting to fix issue by removing mysql data or un/install software.
Anyway i fixed it myself after simple experiment.

I simply clicked on "mysql.exe" first and it did tells me that i have missing "msvcr100.dll" file.
Download from here : https://www.dll-files.com/msvcr100.dll.html

Also there was one more problem when i clicked on "mysqld.exe" it did tells me that i have missing msvcp100.dll file.
Download again from : https://www.dll-files.com/msvcp100.dll.html

After i have downloaded all files
and put them in folder "path_to_your/Ampps/mysql/bin" where "mysql.exe" and "mysqld.exe" reside,
then finally i was able to start the MySQL server.

This solution is only for system Windows.

Upvotes: 0

Related Questions