Starting MySQL. ERROR! The server quit without updating PID file (/mysql3306/data/mysql.pid).

1、MySQL数据库启动报错

[root@mysql ~]# service mysqld start
Starting MySQL. ERROR! The server quit without updating PID file (/mysql3306/data/mysql.pid).

2、排查错误日志

024-01-16T00:46:46.435107Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-01-16T00:46:46.444333Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2024-01-16T00:46:46.444418Z 0 [Note] /mysql3306/bin/mysqld (mysqld 5.7.26-log) starting as process 2110 ...
mysqld: File '/mysql3306/binlog/binlog.index' not found (Errcode: 13 - Permission denied)
2024-01-16T00:46:46.448174Z 0 [ERROR] Aborting

2024-01-16T00:46:46.448194Z 0 [Note] Binlog end
2024-01-16T00:46:46.448337Z 0 [Note] /mysql3306/bin/mysqld: Shutdown complete

具体报错为 mysqld: File '/mysql3306/binlog/binlog.index' not found (Errcode: 13 - Permission denied)

3、排查data目录下的属主（由于昨天导如数据）

[root@mysql data]# ll
total 630920
-rw-r----- 1 mysql mysql        56 Jan  4 01:32 auto.cnf
-rw------- 1 mysql mysql      1675 Jan 13 06:23 ca-key.pem
-rw-r--r-- 1 mysql mysql      1107 Jan 13 06:23 ca.pem
-rw-r--r-- 1 mysql mysql      1107 Jan 13 06:23 client-cert.pem
-rw------- 1 mysql mysql      1675 Jan 13 06:23 client-key.pem
drwxr-x--- 2 mysql mysql       228 Jan 15 04:35 db1
drwxr-x--- 2 mysql mysql       102 Jan  4 01:27 db2
drwxr-x--- 2 mysql mysql        98 Jan  4 01:27 db3
drwxr-x--- 2 mysql mysql        90 Jan  4 02:01 db_itheima
drwxr-x--- 2 root  root        100 Jan 15 04:10 dbt3
-rw-r----- 1 mysql mysql 336720638 Jan 15 04:53 general.log
-rw-r----- 1 root  root      17462 Jan 15 04:53 ib_buffer_pool
-rw-r----- 1 mysql mysql  79691776 Jan 15 04:54 ibdata1
-rw-r----- 1 mysql mysql  50331648 Jan 15 04:54 ib_logfile0
-rw-r----- 1 mysql mysql  50331648 Jan 15 04:52 ib_logfile1
drwxr-x--- 2 mysql mysql        48 Jan  4 01:27 liang
drwxr-x--- 2 mysql mysql      4096 Jan  4 01:27 mysql
drwxr-x--- 2 mysql mysql      8192 Jan  4 01:27 performance_schema
-rw------- 1 mysql mysql      1675 Jan 13 06:23 private_key.pem
-rw-r--r-- 1 mysql mysql       451 Jan 13 06:23 public_key.pem
-rw-r--r-- 1 mysql mysql      1107 Jan 13 06:23 server-cert.pem
-rw------- 1 mysql mysql      1675 Jan 13 06:23 server-key.pem
-rw-r----- 1 mysql mysql 128882889 Jan 15 04:53 slow.log
-rw-r----- 1 mysql mysql       356 Jan 14 01:42 slow_new.log
drwxr-x--- 2 mysql mysql      8192 Jan  4 01:27 sys
drwxr-x--- 2 mysql mysql        90 Jan 14 19:39 test
drwxr-x--- 2 mysql mysql        52 Jan  4 01:27 wen
-rw-r----- 1 mysql mysql        19 Jan  4 01:27 xtrabackup_binlog_pos_innodb
-rw-r----- 1 mysql mysql       471 Jan  4 01:27 xtrabackup_inf

4、将data下的属主都改为mysql

[root@mysql mysql3306]# chown -R mysql:mysql data

5、启动依旧报错

[root@mysql ~]# service mysqld start
Starting MySQL. ERROR! The server quit without updating PID file (/mysql3306/data/mysql.pid).

6、依据第二步报错信息查看binlog.index的属主

-rw-r----- 1 mysql mysql    177 Jan 15 01:16 binlog.000040
-rw-r----- 1 mysql mysql    177 Jan 15 02:37 binlog.000041
-rw-r----- 1 root  root     177 Jan 15 02:48 binlog.000042
-rw-r----- 1 root  root    1512 Jan 15 04:52 binlog.000043
-rw-r----- 1 root  root     198 Jan 15 04:53 binlog.000044
-rw-r----- 1 root  root     177 Jan 15 04:53 binlog.000045
-rw-r----- 1 root  root    1440 Jan 15 04:53 binlog.index

7、修改binlog.index的属主

root@mysql mysql3306]# chown -R mysql:mysql binlog

8、启动成功

[root@mysql ~]# service mysqld start
Starting MySQL. SUCCESS!