Cant start mysql from console

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Cant start mysql from console

Postby Enugras » 19. June 2019 23:27

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
Enugras
 
Posts: 1
Joined: 19. June 2019 23:23
XAMPP version: 3.2.4
Operating System: Windows 10

Re: Cant start mysql from console

Postby dandar » 14. August 2019 20:22

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.
dandar
 
Posts: 1
Joined: 14. August 2019 20:17
XAMPP version: 7.2
Operating System: win


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 105 guests