WAMP MySQL service does not start
18,310
Search for mysql-bin.index file, delete it, then restart MySQL.
Related videos on Youtube
Author by
jzeus
Updated on September 18, 2022Comments
-
jzeus almost 2 years
My question is similar to this. But none of the posted solutions worked.
my.ini
file is pasted here. 'mysql.log' is pasted here.The problem seems to be caused for no reason. I don't remember changing anything specifically.
Apache runs fine. I'm on windows 7 x64.Most interestingly, mysql.exe runs just fine. No password is on. mysqld.exe doesn't run
(running it through console will just cause an infinite delay)What I've tried
- Turning off Firewall
- Checking port 3306 to be open
- Checking running services for other instances of MySQL
- Checking for other installed versions of MySQL
- Changing password in my.ini
- Running wampserver as administrator
- Disabling SQL Server services
- Uncommenting 'skip-networking' option
- Switching my computer's networking mode to DMZ (just in case if router firewall issue)
- Googling and trying every other suggested solution
- Re-installing wampserver
- Restarting PC
I don't know what to do anymore. Anyone has a solution?
-
jzeus over 11 yearsthere was no such socket file in my temp folder :/ I've edited the post and added the log file (it has some stuff about InnoDB...)
-
alex_m over 11 yearsSearch for mysql-bin.index file, delete it, then restart MySQL.
-
jzeus over 11 yearsYES THANK YOU! IT WORKS NOW! I can't believe it was as simple as that. Please move it to your answer for future reference.