ERROR! The server quit without updating PID file (/application/mysql-5.6.40/data/db01-51.pid).

时间:2022-12-27 23:08:52

centos7.5 安装mysql数据库报错

问题:

[root@db01-51 scripts]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/application/mysql-5.6.40/data/db01-51.err'.
190313 15:20:31 mysqld_safe Directory '/application/mysql-5.6.40/tmp' for UNIX socket file don't exists.
ERROR! The server quit without updating PID file (/application/mysql-5.6.40/data/db01-51.pid).

原因:

他说找不到/application/mysql-5.6.40/data/db01-51.pid这个进程,原因有很多,需要查看错误日志

[root@db01-51 scripts]# tail -100 /application/mysql-5.6.40/data/db01-51.err 	#看错误日志

解决方法:

原因一:没有给mysql授权

[root@db01-51 scripts]# chown -R mysql.mysql /application/mysql*