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!