Mengatasi Error MySQL The server quit without updating PID file

Error yang muncul setelah upgrade cPanel

root@perkis [~]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/perkis.dev.com.pid).

ada lagi error

root@perkis [~]# /etc/init.d/mysql status
 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

cek log MySQL

root@perkis [~]# tail -f /var/log/mysqld.log 
110719 12:07:01 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.56'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
110719 19:06:00 [Note] /usr/sbin/mysqld: Normal shutdown
 
110719 19:06:00 [Note] Event Scheduler: Purging the queue. 0 events
110719 19:06:00  InnoDB: Starting shutdown...
110719 19:06:02  InnoDB: Shutdown completed; log sequence number 0 89012
110719 19:06:02 [Note] /usr/sbin/mysqld: Shutdown complete
 
110719 19:06:02 mysqld_safe mysqld from pid file /var/lib/mysql/perkis.dev.com.pid ended

solusi untuk mengatasi masalah diatas
1. Hapus file /var/lock/subsys/mysql

rm -f /var/lock/subsys/mysql

2. Hapus pid file

rm -f /var/lib/mysql/perkis.dev.com.pid

3. Nonaktifkan config MySQL, tambahkan tanda # di depan config

#[mysqld]
#open_files_limit=17070
#max_heap_table_size=20M
#sort_buffer_size=64K
#key_buffer=16K
#default-storage-engine=MyISAM
#local-infile=0
#innodb_file_per_table=1
#table_cache=4
#net_buffer_length=2K
#tmp_table_size=20M
#thread_stack=64K
#read_rnd_buffer_size=256K
#read_buffer_size=256K
#max_allowed_packet=1M
#skip-innodb

sekarang restart MySQL

service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL. SUCCESS!

Reader Interactions

Leave a Reply Cancel reply