MySQL Server on MAMP-Windows Will Not Start

Question

I am using MAMP 4.1 on Windows 10 and cannot get MySQL server to start. When I uninstalled MAMP and re-installed it MySQL server starts up, but when I stop it, it will not start back up. I also went into the \mamp\db\mysql\ and deleted the four log files hilited below. Then I turned the server off, then back on, but only Apache starts up, not MySQL.

There is also a process running in services called MySQL80. When I try to start it I get the error message shown. I have tried many ways to delete it, including going to the command prompt and using "sc mysql80" and going to 'regedit'. MySQL80 does not show up anywhere so that I can delete it.

Also, the Resource Monitor below shows that Apache is running on port 80, but nothing on port 3306. And yes, my MAMP Preferences are set to port 3306 for MySQL.

When MySQL was running, I had 2 processes of 'mysqld' listening: one session on IPv6 Port 3306, and the other session on IPv4 Port 3306?

What's wrong and how do I fix it?

And, is there suppose to be (2) sessions of 'mysqld' both listening on port 3306 where one is on IPv6 and the other is on IPv4?

Thanks Community.

MAMP Control Panel

mysql80 Service

Resource Window with Ports Listed

MAMP Log Files

Answer 1

1. Turn off your MAMP Server.
2. Locate your db folder for mysql. Example: C:\MAMP\db\mysql
3. Rename the mysql-bin.index file to mysql-bin_old.index (or anything really)
4. Turn on your MAMP Server

This is a very common issue with MAMP. If this happened to you out of the blue, this is probably the fix.