MySQL won't start

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

Threaded Mode | Print

MySQL won't start (5 Replies, Read 12032 times)

Aloupha	# February 26, 2018, 12:46 am
Group: Member Post Group: Newbie Posts: 2 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	# February 26, 2018, 2:40 am \| Post: 1
Group: Member Post Group: Newbie Posts: 2 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	# September 11, 2018, 1:17 pm \| Post: 2
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	# October 13, 2018, 3:02 pm \| Post: 3
Group: Member 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	# November 4, 2018, 3:35 pm \| Post: 4
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: --

MySQL won't start

kennysvg	# February 14, 2019, 2:22 pm \| Post: 5
Group: Member Post Group: Newbie Posts: 1 Status:	I had the exact issue described by the OP. Trying to also start MySQL manually would give a vauge error "the application could not start". Event viewer was unhelpful, and every helpful source only mentioned installing C++ packages. I then went to installing wamp and had exactly the same issue, but the errors were more helpful, and I found the solution that way. It's likely permissions / security related, but here's what you should do: - Open the command prompt and navigate to youramppsdirectory/mysql/bin - Run mysqld.exe --initialize-insecure This will create the data directory and files that should be in it. MySQL should then start correctly when you launch Ampps.
IP: --

« Previous Next »

Threaded Mode | Print

Jump To :

Users viewing this topic
	1 guests, 0 users.

All times are GMT. The time now is April 16, 2024, 9:55 am.

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.

Queries: 11 | Page Created In:0.042