The problem occurs after upgrading the PHP version, the site cannot connect to the database, phpMyAdmin cannot log in:
Then try to turn on mysql,/etc/init.d/mysqld start, prompting:
Starting MySQL. error! The server quit without updating PID file (/usr/local/mysql/data/ay12122808152158ea209.pid).
Found MySQL error file under/usr/local/mysql/data ****.err, browse to the last side, found that there is a sentence:
./mysql-bin.index ' not Found (errcode:13)
Hint./mysql-bin.index could not be found (because MySQL turned on the bin log feature), to the database root to see if the file is present, may be a problem with file permissions, and then use the following command to the database directory/usr/local/mysql/data given MySQL Permissions:
1 |
Chgrp-r mysql/usr/local/mysql/data && chown-r mysql/usr/local/mysql/data |
Start again mysql:/etc/init.d/mysqld start, everything is OK.
Resolve./mysql-bin.index ' not Found (errcode:13)