mysql user crash/corrupt
error log di mysql menampilkan sbb:
150719 19:57:18 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
150719 19:57:18 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
untuk perbaikan jalankan perintah
mysqlcheck -r mysql
Comments