Error: MySQL shutdown unexpectedly.

 

Semua pasti bisA Nangis...jika ada pesan kesalahan berikut
Mysql pada XAMPPP Control Panel (localhost/phpmyadmin) GAGAL RUN , dengan pesan

7:33:28 AM  [mysql] Error: MySQL shutdown unexpectedly.
7:33:28 AM  [mysql] This may be due to a blocked port, missing dependencies, 
7:33:28 AM  [mysql] improper privileges, a crash, or a shutdown by another method.
7:33:28 AM  [mysql] Press the Logs button to view error logs and check
7:33:28 AM  [mysql] the Windows Event Viewer for more clues
7:33:28 AM  [mysql] If you need more help, copy and post this
7:33:28 AM  [mysql] entire log window on the forums

Dan pada mysql_error.log muncul pesan berikut:

2024-06-04 18:48:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-06-04 18:48:00 0 [Note] InnoDB: Uses event mutexes
2024-06-04 18:48:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-06-04 18:48:00 0 [Note] InnoDB: Number of pools: 1
2024-06-04 18:48:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-06-04 18:48:00 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2024-06-04 18:48:00 0 [Note] InnoDB: Completed initialization of buffer pool
2024-06-04 18:48:00 0 [ERROR] InnoDB: The Auto-extending innodb_system data file 'C:\xampp\mysql\data\ibdata1' is of a different size 768 pages than specified in the .cnf file: initial 6400 pages, max 0 (relevant if non-zero) pages!
2024-06-04 18:48:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-06-04 18:48:01 0 [Note] InnoDB: Starting shutdown...
2024-06-04 18:48:01 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-06-04 18:48:01 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-06-04 18:48:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-06-04 18:48:01 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-06-04 18:48:01 0 [ERROR] Aborting

SOLUSI:
backup file my.ini yang lama(C:\xampp\mysql\bin\my.ini), lalu isinya ganti dengan ini semua:

 

[client] 
port=3306
socket="C:/xampp/mysql/mysql.sock"
 
default-character-set=utf8mb4
[mysqld]
port=3306
socket="C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid" 
key_buffer=16M
max_allowed_packet=1M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log_error="mysql_error.log" 
plugin_dir="C:/xampp/mysql/lib/plugin/" 
server-id =1
 
innodb_data_home_dir="C:/xampp/mysql/data"
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir="C:/xampp/mysql/data" 
innodb_buffer_pool_size=16M 
innodb_log_file_size=5M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50 
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
log_bin_trust_function_creators=1

character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
[mysqldump]
max_allowed_packet=16M

[mysql] 
[isamchk]
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M

[myisamchk]
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]