[Ask]ERROR! MySQL server PID file could not be found!

[T36o3h]

Aku baru restart mysql dan muncul ERROR! MySQL server PID file could not be found! di lognya kenapa ya ??
Aku pake centos dan cpanel ...
Tolong dibantu ya para master sekalian

 

[masiqbal]

Coba cek apa yang terjadi di: /var/lib/mysql/<nama hostname server>.err

 

[T36o3h]

InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141124 6:06:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
141124 6:06:50 InnoDB: Waiting for the background threads to start
141124 6:06:51 InnoDB: 5.5.40 started; log sequence number 362324147
141124 6:06:51 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141124 06:06:46 mysqld_safe Starting mysqld daemon with databases from /var/lib$
141124 6:06:46 [Note] Plugin 'FEDERATED' is disabled.
141124 6:06:47 InnoDB: The InnoDB memory heap is disabled
141124 6:06:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141124 6:06:47 InnoDB: Compressed tables use zlib 1.2.3
141124 6:06:47 InnoDB: Using Linux native AIO
141124 6:06:47 InnoDB: Initializing buffer pool, size = 128.0M
141124 6:06:47 InnoDB: Completed initialization of buffer pool
141124 6:06:47 InnoDB: highest supported file format is Barracuda.
itu hasilnya ...

 

[masiqbal]

Cuman itu doang? Coba cek proses mysql seperti apa? Apakah di situ ketahuan pid file-nya di mana lokasinya. biasanya di --pid-file=sebuah file

ps aux|grep mysql

Nah, coba cek pid tersebut ada apa tidak? Kalau ada apakah ownersihp dan permissionnya sudah benar.

 

[T36o3h]

root 21786 0.4 0.0 9476 1652 ? S 13:53 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/ix.balihostingmurah.com.pid
mysql 28002 14.0 2.4 384532 45196 ? Sl 13:57 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ix.balihostingmurah.com.err --pid-file=/var/lib/mysql/ix.balihostingmurah.com.pid
root 28020 0.0 0.0 6440 708 pts/0 S+ 13:57 0:00 grep mysql

 

[masiqbal]

coba:

ls -l /var/lib/mysql/ix.balihostingmurah.com.pid

Harusnya dapat response seperti ini:

-rw-rw----. 1 mysql mysql 5 Aug 24 12:27 /var/lib/mysql/ix.balihostingmurah.com.pid

 

[T36o3h]

/bin/ls: cannot access /var/lib/mysql/ix.balihostingmurah.com.pid: No such file or directory

 

[masiqbal]

Nah berarti pid file gak ada ya? Atau Anda login bukan sebagai root?
Kalau pid file tidak ada, bisa dibuat dengan cara begini:


touch /var/lib/mysql/ix.balihostingmurah.com.pid
chown mysql:mysql /var/lib/mysql/ix.balihostingmurah.com.pid

 

[T36o3h]

saya masuk pake root
sudah saya cb hasilnya :
chown: cannot access `/var/lib/mysql/ix.balihostingmurah.com.pid': No such file or directory

 

[masiqbal]

Perintah ini dulu:

touch /var/lib/mysql/ix.balihostingmurah.com.pid
baru
chown mysql:mysql /var/lib/mysql/ix.balihostingmurah.com.pid