MySQL failure: Start error after restarting MySQL

Yesterday in the test run the environment to do the system upgrade, suddenly SSH connection disconnect, try to connect always error, and then restart my computer to connect again, still error, strange test personnel visit the company's Liferay interface can be normal access, Later to the department colleagues called to ask whether they have any changes to the test run environment today, two colleagues are said to have not done any operation on the test run server, I did not do anything, and later with the computer room technical support call consulting a bit, Technical support said that the room today also did not do what the operation is not to do what restrictions, and then log on to the XenServer to try to run the machine, found no abnormalities, but also deliberately looked at the SSH connection number, check log also did not find the exception, restart the SSH service, still not connected, As a result of the upgrade, the feeling of desperation, restarted the trial run of the physical machine, but to check the status of the MySQL service, the error is as follows:

[[email protected] mysql]# /etc/rc.d/init.d/mysql statusmysql is not  running, but lock file  (/var/lock/subsys/mysql[failed] Move the/var/lock/subsys/mysql file to/tmp, Start the MySQL service with the following error mv /var/lock/subsys/mysql /tmp[[email protected] mysql]# /etc/rc.d/ Init.d/mysql startstarting mysql ... the server quit without updating pid file  (/usr/local/mysql/data/ LOCALHOST.LOCALDOMAIN.PID) .                               [failed] View the error log and find key information: '/log/mysqlbinlog/mysql-bin.index '  not found  (errcode: 13 -  permission denied) 150527 21:27:56 mysqld_safe mysqld from pid file / data_mysql/mysqldata/mysql.pid ended150527 21:29:13 mysqld_safe starting mysqld Daemon with databases from /data_mysql/mysqldata/usr/local/mysql/bin/mysqld: file   '/log/mysqlbinlog/mysql-bin.~rec~ '  not found  (errcode: 13 - permission  denied) 2015-05-27 21:29:15 2151 [error] mysql_bin_log::open_purge_index_file  failed to open register  file.2015-05-27 21:29:15 2151 [error]  mysql_bin_log::open_index_file failed to sync the index file.2015-05-27  21:29:15 2151 [error] aborting reason: Because MySQL and corporate applications are deployed on the same machine, the Mysqlbinlog directory is moved to the/log directory, and/ Log is the uniform storage path of the server log, along with its subdirectory owners and groups are all ordinary user tomcat, view/log/mysqlbinlog's owner and group is also Tomcat, oh, the original is the issue of permissions. Workaround: Modify the Mysqlbinlog directory and subdirectories of the genus Master Group to MySQL, and then start the MySQL service chown -r mysql:mysql mysqlbinlog /etc/ Init.d/mysqld start

This article is from the Nagios failure blog, so be sure to keep this source http://5250070.blog.51cto.com/5240070/1656123

MySQL failure: Start error after restarting MySQL