mysql-5.6.25-linux-glibc2.5-i686.tar.gz Error

Start mysqld Service display:

[[Email protected] data]# service mysqld start

Error reason analysis:

    online view of many netizens ' documents, combined with error log analysis: The original is already exists MySQL process

WORKAROUND: Use the command "Ps-a | grep mysqld "To see if there is a mysqld process, kill with the kill-9 process number, and then restart mysqld!

Here are some solutions that might cause such errors:

1. may be/usr/local/mysql/data/rekfan.pid file does not have permission to write

workaround: Give permission, execute   "Chown -r Mysql:mysql /var/data "  Chmod-r 755/usr/local/mysql/data" and then restart mysqld!

    2. The MySQL process already exists in the process
Workaround: Use the command" Ps-ef|grep mysqld " Check to see if there is a mysqld process, kill with the kill-9  process number, and then restart the mysqld! < Span style= "line-height:0px;" >

    3. May be the second time to install MySQL on the machine, there is residual data affecting the start of the service .
Workaround: Go to MySQL data directory/data See, if there is mysql-bin.index, quickly delete it, it is the culprit.

    4.mysql The/ETC/MY.CNF profile is used when the configuration file is not specified at startup, open this file to view the [mysqld] section There is no specified data directory (DATADIR).
Workaround: Please set this line under [mysqld]: DataDir = /usr/local/mysql/data

    5.skip-federated field problem
workaround: Check/etc/ There are no skip-federated fields in the my.cnf file that are not commented out, and if so, comment them out immediately. < Span style= "line-height:0px;" >

    6. Error log directory does not exist
Workaround: Use" Chown "" chmod " Command gives MySQL owner and permissions

7.selinux, if it is a CentOS system, the default is to turn on SELinux
Workaround: Close it, open the/etc/selinux/config, change theselinux=enf orcing to selinux=disabled and then save the restart machine . .  

This article is from "Luo Chen's blog" blog, please be sure to keep this source http://luochen2015.blog.51cto.com/9772274/1695763

mysql-5.6.25-linux-glibc2.5-i686.tar.gz Error