Objective: To turn on MySQL binlog.
environment: CentOS6.5, MySQL5.6.10.
question: Starting MySQL… ERROR! The server quit without updating The PID file (/ var/lib/mysql/common PID).
view: in the MySQL data directory to view the log, the log named hostname. Err, after view there is the following error message. It is verified to be a bug of MySQL version.
solution: use the log – bin =/var/lib/mysql/mysql – bin instead of the original three lines of configuration. The modified restart was successful.
validation: execute SQL:
environment: CentOS6.5, MySQL5.6.10.
question: Starting MySQL… ERROR! The server quit without updating The PID file (/ var/lib/mysql/common PID).
view: in the MySQL data directory to view the log, the log named hostname. Err, after view there is the following error message. It is verified to be a bug of MySQL version.
solution: use the log – bin =/var/lib/mysql/mysql – bin instead of the original three lines of configuration. The modified restart was successful.
validation: execute SQL:
show variables like '%log_bin%';As a result, the Binlog log was successfully turned on.
Read More:
- The server just without updating PID file and can’t connect to local MySQL server through socket are solved
- MySQL server PID file could not be found!
- When MySQL is running, the server suddenly goes down, which causes Mysql to be unable to restart
- CentOS7 nginx Failed to read PID from file /run/nginx.pid: Invalid argument？
- The MySQL server is running with the — secure file priv option
- (error when importing database): MySQL 2006-mysql server has gone away
- Error kernel restart: restart failed was reported in the background of jupyter notebook
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- Ntpdate reported an error when updating the clock, and the problem of no server suitable for synchronization found was solved
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- Plug in loaded: fastmirror, langpacks / var / run/ yum.pid Locked, another program with PID 2323 is running
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
- nginx: [error] invalid PID number ““ in “/data/nginx/logs/nginx.pid“
- nginx: [error] invalid PID number in /var/run/nginx.pid
- /var/run/nginx/nginx.pid” failed (2: No such file or directory)
- Node.JS “Cannot enqueue Handshake after invoking quit” Error (Fixed)
- Nginx error: nginx: [error] invalid PID number “” in “/run/nginx.pid”
- Import / export. SQL file / gzip file for MySQL under Linux