Problem:
C:\huypv>net start mysql
The mysql service is starting.
The mysql service could not be started.
#eventvwr
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
# mysql error log
Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and should be repaired
For more information, see Help and Support Center at http://www.mysql.com.
Solved:
Edit file my.ini
Add line
innodb_force_recovery = 1
for [mysqld]
Start MySQL server with option --skip-grant-tables
Use MySQL client:
check table user;
repair table user;
Stop MySQL. Remove appended line in my.ini. Start MySQL server again, without option --skip-grant-tables
Title:
Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and should be repaired
Description:
Problem: C:\huypv>net start mysql The mysql service is starting. The mysql service could not be started. #eventvwr A system error h...
...
Rating:
4