MYSQL Tidak Bisa Nyala "I/O error reading the header from the binary log"

cat /var/log/mysql/error.log

2023-01-30T07:22:07.127143Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-0ubuntu0.20.04.2) starting as process 3873063
2023-01-30T07:22:07.141127Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-30T07:22:07.504223Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-01-30T07:22:07.687307Z 0 [ERROR] [MY-010958] [Server] I/O error reading the header from the binary log.
2023-01-30T07:22:07.687347Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2023-01-30T07:22:07.687355Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-01-30T07:22:09.161742Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32-0ubuntu0.20.04.2)  (Ubuntu).

Cara solving nya adalah:

1. Masuk ke path system mysql : cd /var/lib/mysql
2. Backup semua file binlog.000* ke folder lain (semisal folder backup) : mkdir /backup && mv binlog.000* /backup
3. Backup file binlog.index : cp binlog.index binlog.index-backup
4. Hapus semua isi didalam folder binlog.index : echo "" > binlog.index
5. Jalankan kembali mysql nya : /etc/init.d/mysql start

Selesai 👍