Page 1 of 1

Cant start mysql from console

PostPosted: 19. June 2019 23:27
by Enugras
my [Error] logs are as follows, any help would be much appreciated, it was working fine yesterday and now for some reason MySQL shutsdown unexpectedly on start

2019-06-19 10:20:25 0 [ERROR] mysqld.exe: Table '.\mysql\user' is marked as crashed and should be repairedhea
2019-06-19 10:20:25 0 [ERROR] mysqld.exe: Index for table '.\mysql\user' is corrupt; try to repair it
2019-06-19 10:20:25 0 [ERROR] Couldn't repair table: mysql.user
2019-06-19 10:20:25 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'user' is corrupt; try to repair it

Re: Cant start mysql from console

PostPosted: 14. August 2019 20:22
by dandar
I have same issue. Happened after a reboot without graceful shutdown .... following failed to fix the problem:

mysqlcheck --repair --all-databases

mysqld --initialize-insecure

Both seem to need mysql running to repair.