mysql報錯Do you already have another mysqld server running on socket

背景：啟動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

将該路徑配置設定給mysql使用者重新開機mysql，問題解決

# chown -R mysql.mysql tmp/
# /etc/init.d/mysqld start
Starting MySQL....... SUCCESS!       

轉載于:https://www.cnblogs.com/ExzaiTin/p/8280302.html