The MySQL service on Local Computer started and then stopped

[Mike Alhayek]

I have MySQL 8.0.16 installed on Windows Server 2016. It was running with no problem. Then I had a need to use LOAD DATA LOCAL INFILE command which required me to add this to my.ini file secure-file-priv=''

I tried to restart the server but I am getting the following error image description here

"The MySQL service on Local Computer started and then stopped"

I removed the secure-file-priv='' line from `my.ini` file, but I am still getting the same problem when trying to start it. I restarted the whole machine but still the same problem.

I looked a the .err file but there is nothing there that tells me why it is not working.

What can I do to get it started again?

I tried to start mysql from the command line like so net start mysql --verbose then got the following

The MySQL service is starting.
The MySQL service could not be started.
The service did not report an error.
More help is available by typing NET HELPMSG 3534.

typing NET HELPMSG 3534 return The service did not report an error.

Additionally, NETWORK SERVICE has full control permission on the Data folder

I also tried mysql --initialize but it is just hanging. Nothing is happening on the screen


How can I get my production server back up?