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.
