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
- [Solved] Starting MySQL… ERROR The server quit without updating PID file
- MySql Warning: The server quit without updating PID file error
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- mac brew install mysql ‘/tmp/mysql.sock’ (2) [How to Solve]
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)