ERROR! The server quit without updating PID file 에러 발생

/home/APM/mysql/support-files/mysql.server start 실행시

 

위와 같은 에러 발생!

 

원인은 여럿 이지만

 

1.mysql.server 쪽에 basedir, datadir 경로 지정

2.mysql이 있는 경로 예를들어 /home/APM/mysql 디렉토리 권한(mysql 소유자)이 mysql 이어야 한다.

ㄴ chown -R mysql.mysql /home/APM/mysql

 

 

 

1. 두번쨰 조치

/etc/my.cnf 에 다음과  같이 넣고 /opt/mysql/support_files/mysql.server start 로 구동하면 된다

 

[mysqld]

datadir=/opt/mysql/var

socket=/tmp/mysql.sock

 

[mysql]

socket=/tmp/mysql.sock

 

 

 

1. 세번째 조치

[root@q391-2916 /opt/mysql/var]# cd /tmp

[root@q391-2916 /tmp]# ll

total 92

lrwxrwxrwx 1 root   root     25 2023-04-02 17:38 mysql.sock -> /var/lib/mysql/mysql.sock

drwxr-xr-x 3 root   root     18 2023-04-03 11:31 pear

-rw------- 1 daemon daemon  174 2023-04-03 13:47 sess_396d9050f85e105cce8fb641a0423380

-rw------- 1 daemon daemon  174 2023-04-03 13:43 sess_63de2b8824d4b614916c50551d037a3c

-rw------- 1 daemon daemon  174 2023-04-03 14:36 sess_7022c1f4939d092e9a2ece6f8f9117f3

-rw------- 1 daemon daemon  174 2023-04-03 13:51 sess_7bfb7bc346610a82d3f7d57aa18e217c

-rw------- 1 daemon daemon  174 2023-04-03 13:36 sess_85001b309556dc5df0e8fc22be261acf

-rw------- 1 daemon daemon  174 2023-04-03 13:44 sess_858fb7294c72abd695987f917c9a5467

-rw------- 1 daemon daemon  174 2023-04-03 13:35 sess_8c87207bfd0705214d29927e99d2b3c3

-rw------- 1 daemon daemon  174 2023-04-03 14:06 sess_cbd9be35a5c2901a3d7aac744219b8ed

-rw------- 1 daemon daemon  174 2023-04-03 13:44 sess_dd8067b79cdb846e28fbf3b9cabf8c92

-rw------- 1 daemon daemon  174 2023-04-03 13:57 sess_f1cbb59cec39c42d012b988899d2a31e

drwx------ 2 root   root     57 2023-04-02 17:21 yum-root-ErRhPT

-rw------- 1 root   root   2744 2023-03-29 18:53 yum_save_tx.2023-03-29.18-53.ZNWIgQ.yumtx

-rw------- 1 root   root   2744 2023-03-29 18:54 yum_save_tx.2023-03-29.18-54.hAWmx8.yumtx

-rw------- 1 root   root   3027 2023-04-02 02:57 yum_save_tx.2023-04-02.02-57.tUwNsY.yumtx

-rw------- 1 root   root   1235 2023-04-02 17:22 yum_save_tx.2023-04-02.17-22.UkA4sm.yumtx

-rw------- 1 root   root    769 2023-04-02 22:44 yum_save_tx.2023-04-02.22-44.iD2P6h.yumtx

-rw------- 1 root   root    832 2023-04-02 22:45 yum_save_tx.2023-04-02.22-45.7eNDwu.yumtx

-rw------- 1 root   root   2617 2023-04-03 13:23 yum_save_tx.2023-04-03.13-23.skHHmx.yumtx

-rw------- 1 root   root    513 2023-04-03 13:30 yum_save_tx.2023-04-03.13-30.2fWJRb.yumtx

-rw------- 1 root   root    513 2023-04-03 13:31 yum_save_tx.2023-04-03.13-31.Pmfwm_.yumtx

-rw------- 1 root   root    513 2023-04-03 13:33 yum_save_tx.2023-04-03.13-33.f0SSt8.yumtx

-rw------- 1 root   root   1060 2023-04-03 13:36 yum_save_tx.2023-04-03.13-36.JiJJ86.yumtx

-rw------- 1 root   root    513 2023-04-03 13:53 yum_save_tx.2023-04-03.13-53.XUPo9Z.yumtx

-rw------- 1 root   root    832 2023-04-03 13:58 yum_save_tx.2023-04-03.13-58.EvG9X4.yumtx

[root@q391-2916 /tmp]# rm -f mysql.sock

 

삭제후 구동 완료

 

[root@q391-2916 ~]# /opt/mysql/support-files/mysql.server start

Starting MySQL.. SUCCESS!