MySQL not Starting in AMPPS

Question

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.

score 13 · Answer 1 · edited Jan 28 '18 at 13:00

13

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 :)

edited Jan 28 '18 at 13:00

Dmitriy

5,525
12
25
38

answered Jan 28 '18 at 12:42

Wojciech A.

174
1
13

This is the best answer I’ve found anywhere. Thanks! – Chuck Le Butt Mar 27 '18 at 18:10
**Download the 32-bit version as AMPPS is 32-bit.** – Anoop Naik May 04 '18 at 22:18
AMPSS 3.8 includes redist 2017 but it seems that mysql need 2010 :) – Ondřej Stašek Aug 28 '18 at 14:40

score 5 · Answer 2 · answered Mar 07 '18 at 14:54

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

score 3 · Answer 3 · answered Mar 26 '20 at 09:13

3

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

answered Mar 26 '20 at 09:13

bhushan deshmukh

55
7

score 1 · Answer 4 · answered Aug 28 '19 at 06:47

1

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.

answered Aug 28 '19 at 06:47

Udara Herath

805
2
18
37

score 0 · Answer 5 · answered Jan 09 '18 at 21:06

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.

**Download the 32-bit version of dll files as AMPPS is 32-bit.** — Anoop Naik, May 04 '18 at 22:19

score 0 · Answer 6 · edited Sep 13 '20 at 05:39

0

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.

edited Sep 13 '20 at 05:39

סטנלי גרונן

2,917
23
46
68

answered Sep 13 '20 at 03:14

Richard Apuliba

1
1

score 0 · Answer 7 · answered Jul 15 '23 at 14:06

0

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

answered Jul 15 '23 at 14:06

Lalarukh khan

95
7

MySQL not Starting in AMPPS

7 Answers7