• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Jaranguda

Belajar Mengajar

  • Home
  • Sponsor/Jasa
  • Tentang

Mengatasi Error MySQL The server quit without updating PID file

Last Updated on 2 April 2014 By tommy Leave a Comment

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!

Tulisan menarik lainnya

  • Mengatasi HTTP Error 500 Internal Server untuk PHP

    Salah satu masalah yang paling sering muncul di PHP adalah 500 - Internal Server Error.…

  • Mengatasi Error MySQL logger: command not found Debian

    Error yang muncul sewaktu menginstall mysql di Debian 7 Setting up mysql-server-5.5 (5.5.40-0+wheezy1) ... debconf:…

  • Mengatasi Error mysql.service has failed

    Log errornya dilihat dari journal -xn -- Unit mysql.service has begun starting up. Feb 12…

  • Mengatasi Error MySQL Unknown/unsupported storage engine: InnoDB

    Error sewaktu menjalankan MySQL $ service mysql start [FAIL] Starting MySQL database server: mysqld .…

Filed Under: Linux Tagged With: mysql

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Pencarian

Tanya Jawab tentang DevOps SRE CPE, gabung di https://t.me/devopsindonesia

Terbaru

  • Solusi AWS CLI SSL VALIDATION failed
  • Monitoring Kubernetes Cluster dengan Prometheus
  • Solusi Playwright Firefox version `GLIBCXX_3.4.30′ not found (required by /lib64/libicuuc.so.69)
  • Cara Upgrade Fedora 35 ke Fedora 36
  • Ekstrak Gzip File dan Ambil Total dengan Python

Komentar

  • Xpud on Script PHP untuk Mengambil History Lagu Shoutcast v2.5
  • Jrenx on Membuat Bot Telegram Sederhana dengan PHP
  • Sella on Kemana Menghilangnya Saldo BCA 50 ribu
  • Rian on Mengganti Halaman Error Laravel
  • Suchie on Kemana Menghilangnya Saldo BCA 50 ribu

Tulisan Populer

  • Password Router Huawei HG8245H5 Indihome 1m views
  • Password Terbaru ZTE F609 Indihome 781.5k views
  • Password Superadmin Huawei HG8245A 294.5k views
  • Cara Setting Manual Modem GPON ZTE F609 Indihome 267.9k views
  • Cara Setting Wireless ZTE F609 Indihome 251k views
  • Mengaktifkan Port LAN di Huawei HG8245 Indihome 165.4k views
  • Akses UseeTV Indihome via Wireless ZTE F609 154.8k views
  • Cara Reset Password ZTE F609 Indihome 146k views
  • Kemana Menghilangnya Saldo BCA 50 ribu 135.4k views
  • Cara Setting DHCP Server Modem/Router ZTE F609 109k views

Kategori

  • Delphi
  • dll
  • Gambas
  • Internet
  • Java
  • Lazarus
  • Linux
  • PHP
  • Review
  • Teknologi

Sponsor

kadal.id
Untuk jadi sponsor, hubungi kita lewat halaman sponsor
© 2021. Jaranguda
  • Linux
  • PHP
  • Internet
  • Teknologi
  • Delphi
  • Gambas
  • Java