Linuxmysql error: MYSQL: TheserverquitwithoutupdatingPID_MySQL

Linuxmysql error: MYSQL: TheserverquitwithoutupdatingPIDfile bitsCN.com

1. it may be that the/usr/local/mysql/data/rekfan. pid file has no write permission.
Solution: Grant permissions, execute "chown-R mysql: mysql/var/data" "chmod-R 755/usr/local/mysql/data", and then restart mysqld!

2. the mysql process may already exist in the process.
Solution: Run "ps-ef | grep mysqld" to check whether the mysqld process exists. if the "kill-9 process number" is used to kill the process and restart mysqld!

3. it may be the second time that mysql is installed on the machine. residual data affects service startup.
Solution: go to the mysql data directory/data to see, if there is a mysql-bin.index, just remove it, it is the culprit.

4. mysql uses/etc/my when the configuration file is not specified at startup. cnf configuration file. open this file to check whether the data directory (datadir) is specified in [mysqld ).
Solution: set this line in [mysqld]: datadir =/usr/local/mysql/data

5. skip-federated field problems
Solution: Check whether the skip-federated field has been commented out in the/etc/my. cnf file. if so, comment out the field immediately.

6. the error log directory does not exist.
Solution: Use the "chown" "chmod" command to grant the mysql owner and permissions.

7. selinux. if it is a centos system, selinux is enabled by default.
Solution: close it, open/etc/selinux/config, change SELINUX = enforcing to SELINUX = disabled, and then save the disk and restart the machine.

BitsCN.com