'MySQL Server Stopped -The MYSQL80 service started and then stopped
I had been running a MySQL server for weeks now. Everything had been working perfectly until yesterday, when the MySQL server simply stopped. I realized the Service had stopped, and whenever I try to start it I get an error message that says "The MySQL80 service on Local Server started and then stopped. Some services stop automatically if they are not in use by other programs or services."
So far, I have done some research online and have found solutions that include modifying the my.ini file. After looking for it for quite a while, I realized it wasn't being stored in Program Files, but in the hidden ProgramData folder. I opened the my.ini file and it was empty (I am not sure if this File is generated every time the service starts or if there should already be something in there).
Other solutions include running the mysqld --install and mysqld --initilize commands, but my Command Prompt won't recognize these commands. I am pretty much lost as to what to attempt now, and I am also pretty much confused since it had been running for weeks without any issues whatsoever.
What are some more troubleshooting steps for this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|