1. System configuration information:
System MacOS bigsur 11.6
MySQL 8.0.26
2. Start MySQL service:
sudo /usr/local/mysql/support-files/mysql. server start
The error message is as follows:
Starting MySQL
.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/jinjideleishen.local.pid).
Solution commands
mac default user is _mysql, under linux the default user of mysql is mysql
Use chown to change the owner of the specified file to the specified user or group
-R : Process all files in the specified directory and its subdirectories
sudo chown -R _mysql:_mysql /usr/local/mysql/
Restart successful:
sudo /usr/local/mysql/support-files/mysql.server restart
ERROR! MySQL server PID file could not be found!
Starting MySQL
.................................................... SUCCESS!
3. Stop MySQL service
sudo /usr/local/mysql/support-files/mysql.server stop
4. Restart MySQL service
sudo /usr/local/mysql/support-files/mysql.server restart
Read More:
- [Solved] MySQL Startup Error: The server quit without updating PID file
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- [Solved] mysqldump Command Error: Got error: 2002: “Can‘t connect to server on ‘127.0.0.1‘ (36)“ when trying to connect
- [Solved] CentOS installs MySQL and starts MySQL with error 2002 (HY000)
- [Solved] Starting MySQL… ERROR The server quit without updating PID file
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- MYSQL8 Startup Error: mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘
- [Solved] Access denied for user ‘root‘@‘localhost‘ (using password: YES)
- mac brew install mysql ‘/tmp/mysql.sock’ (2) [How to Solve]
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- Centos7 Initialize mysql Error: Could not open file ‘/usr/local/mysql/log/mysqld.log‘ for error logging: Per
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- Mysql ERROR 1067: Invalid default value for ‘date’ [How to Solve]
- MySql Warning: The server quit without updating PID file error
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- [Solved] mariadb Startup Error: Job for mariadb.service failed because the control process exited with error code.