MySQL: ERROR 1194 (HY000): Table 'user' is marked as crashed and should be repaired

By xngo on April 3, 2019

When you get the following MySQL errors:

ERROR 1133 (28000): Can't find any matching row in the user table
ERROR 1194 (HY000): Table 'user' is marked as crashed and should be repaired

Run:

mysqlcheck --repair --all-databases

About the author

Xuan Ngo is the founder of OpenWritings.net. He currently lives in Montreal, Canada. He loves to write about programming and open source subjects.