MySQL not Starting in AMPPS

mysql ampps
skay picture skay · Nov 21, 2017 · Viewed 21.7k times · Source

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.

Answer

Wojciech A. picture Wojciech A. · Jan 28, 2018

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

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More