Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : MySQL won't start



Threaded Mode | Print  

 MySQL won't start (4 Replies, Read 2323 times)
Aloupha
Group: Member
Post Group: Newbie
Posts: 4
Status:
Hello,

I did a fresh install of Windows 10 and installed Ampps 3.8. Apache and PHP start but MySQL doesn't. I mean it doesn't start and turn off, it just does not start at all. Clicking the Grayed Off button does nothing.

I followed the usual instruction from the wiki in the URL below, and it still does not work.

http://www.ampps.com/wiki/MySQL_is_Not_Running

What do I need to do to get MySQL to start?

Thanks
IP: --   

MySQL won't start
Aloupha
Group: Member
Post Group: Newbie
Posts: 4
Status:
I was curious, so I uninstalled 3.8 and installed the dev package version and MySQL had no problem starting.

At any rate, I was able to fix the problem by following the information below from stackoverflow.com. I hope this helps someone else.

Quote

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

https://stackoverflow.com/questions/47407106/mysql-not-starting-in-ampps
IP: --   

MySQL won't start
fchojinski
Group: Member
Post Group: Newbie
Posts: 5
Status:
Hi,
the hint about the c++ Packages solved my problem. Thanks a lot!
Frank
IP: --   

MySQL won't start
Rishi_P
Group: AMPPS Team
Post Group: Elite Member
Posts: 317
Status:
Hi,

Please install Microsoft Visual C++ 2010 Redistributable Package (x86):
https://www.microsoft.com/en-in/download/details.aspx?id=5555

If you are still facing the same issue then please open a support ticket here.
https://www.softaculous.com/support/
IP: --   

MySQL won't start
flip-flopmedia
Group: Member
Post Group: Newbie
Posts: 1
Status:
Fixed my issue with MySQL not starting. My issue began when I switched to PHP 7.1... from then on, MySQL would no longer start.

I tried ALL of the suggested C++ downloads to no avail.
So! I downloaded a legit PHP 7.1 package from php.net: https://windows.php.net/download#php-7.1
I deleted everything provided by Ampps in the "php-7.1" folder.
I extracted my fresh download and placed all the new files into the "php-7.1" folder.
Switched to PHP 7.1 through Ampps control panel, and VOILA!
No more hiccups!!!
I would suggest that you switch to PHP 5.6 prior to swapping out the PHP 7.1 files.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is December 10, 2018, 5:49 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.303