mysql启动报The server quit without updating PID file问题

控制台启动mysql报错，提示The server quit without updating PID file，查看mysql日志内容如下

2021-08-27T00:53:02.6NZ mysqld_safe Logging to '/Library/Java/developer/mysql-8.0.24/logs/error.log'.
2021-08-27T00:53:02.6NZ mysqld_safe Starting mysqld daemon with databases from /Library/Java/developer/mysql-8.0.24/data
2021-08-27T08:53:03.229374+08:00 0 [System] [MY-010116] [Server] /Library/Java/developer/mysql-8.0.24/bin/mysqld (mysqld 8.0.24) starting as process 1931
2021-08-27T08:53:03.239127+08:00 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
2021-08-27T08:53:03.265478+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-08-27T08:53:03.860469+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-08-27T08:53:04.525204+08:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-08-27T08:53:04.541519+08:00 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2021-08-27T08:53:04.547137+08:00 0 [System] [MY-010232] [Server] XA crash recovery finished.
2021-08-27T08:53:04.625248+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-08-27T08:53:04.625624+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-08-27T08:53:04.628692+08:00 0 [ERROR] [MY-010259] [Server] Another process with pid 1290 is using unix socket file.
2021-08-27T08:53:04.629023+08:00 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2021-08-27T08:53:04.629578+08:00 0 [ERROR] [MY-010119] [Server] Aborting
2021-08-27T08:53:05.567094+08:00 0 [System] [MY-010910] [Server] /Library/Java/developer/mysql-8.0.24/bin/mysqld: Shutdown complete (mysqld 8.0.24)  MySQL Community Server - GPL.
2021-08-27T00:53:05.6NZ mysqld_safe mysqld from pid file /Library/Java/developer/mysql-8.0.24/data/mysql.pid ended

发下如下错误

2021-08-27T08:53:04.628692+08:00 0 [ERROR] [MY-010259] [Server] Another process with pid 1290 is using unix socket file.
2021-08-27T08:53:04.629023+08:00 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2021-08-27T08:53:04.629578+08:00 0 [ERROR] [MY-010119] [Server] Aborting
2021-08-27T08:53:05.567094+08:00 0 [System] [MY-010910] [Server] 

查看mysql部署目录下data目录发现已经mysql.sock.lock文件

此文件作用

mysql.sock的作用是server和client在同一台服务器，并且使用localhost进行链接的时候，就会使用socket来进行连接——仅此而

已，也就是：为主机名为localhost建立的MySQL连接，该连接过程通过一个套接字文件mysql.socket实现的

解决办法

备份后删除此文件重启服务即可