背景:启动mysql失败报错如下显示
# /etc/init.d/mysqld start
Starting MySQL...... ERROR! The server quit without updating PID file (/mysql/data/DB-1.pid).
查看日志发现了如下两条:
2018-01-13 16:57:13 19796 [ERROR] Do you already have another mysqld server running on socket: /application/mysql-5.6.36/tmp/mysql.sock ?
2018-01-13 16:57:13 19796 [ERROR] Aborting
发现问题出在/application/mysql-5.6.36/tmp/mysql.sock
检查/etc/my.cnf下mysql配置文件确认sock文件在/appkication/mysql/tmp下
[mysqld]
user=mysql
port=3306
socket=/application/mysql-5.6.36/tmp/mysql.sock
basedir=/application/mysql
datadir=/mysql/data
server-id=3306
general_log=off
log-error=/mysql/error.log
log-bin=/mysql/log/bin-log
binlog-format=ROW
检查该路径发现tmp路径属于root
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIyZuBnL2QDMyATO1ADOx0iN2AzMyIDM5EzMxEDM4EDMy0CO2EDM2ITMvwVMwgTMwIzLchjNxAjNyEzLcd2bsJ2Lc12bj5ycn9Gbi52YucTMwIzcldWYtl2Lc9CX6MHc0RHaiojIsJye.png)
将该路径分配给mysql用户重启mysql,问题解决
# chown -R mysql.mysql tmp/
# /etc/init.d/mysqld start
Starting MySQL....... SUCCESS!
转载于:https://www.cnblogs.com/ExzaiTin/p/8280302.html