Everything was working fine from last few weeks, but today suddenly Mysql server stopped. Now when I am trying to restart it, different errors are coming with respect to the way I am starting the server.
If starting from Terminal using `mysqld`, the command get stuck and nothing happens:
If start MySQL server from MacOs system preference, on clicking the start button nothing happens.
I checked for the error logs and I think found the stack where the server suddenly got crashed.
I gone through the links suggested in the logs, and found that
1. either this could be caused by a bug
2. or it could be some corrupted data error.
But the data in tables is hardly 5-6 rows and that is text and number. So what is "corrupted data" means here?
I am newbie to MYSQL, how can I be sure that whether it's a bug or something else.
**MYSQL version - 8.0.11**
I suggest that you run mysqlcheck with the --auto-repair and --all-databases options. Depending on the database and the data in the database this could take some time to complete.
There are many other options for mysqlcheck which you may want to look into as well.
“The strongest of all warriors are these two — Time and Patience.” ― Leo Tolstoy, War and Peace
I changed the mysql root privileges - didn't help
created a my.cnf file under /etc/mysql folder - didn't help (/data/ directory error)
in my.conf file, give the path of /data directory - didn't help
And since it was taking a lot of time to debug the issue, and nothing was under my Database, I decided to delete the MYSQL and reinstall it. Reinstalling it resolved the issue.
I don't remember exact files of previous installation but I noticed some difference is ..../mysql/ directory this time.
Installation created /data/ directory from root user this time.
I will suppress my every urge. But not this shameless plug: