Monday, July 20, 2015

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


 
untuk perbaikan jalankan perintah
 

mysqlcheck -r mysql

No comments:

Cara upload dengan git tanpa menyertakan folder tertentu

  Untuk mengupload kode menggunakan Git tanpa menyertakan folder tertentu, Anda perlu menggunakan file khusus bernama .gitignore . File ini...