mysqladmin -u root -p ping
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
# 找到實際 socket 位置
find / -name mysql.sock 2>/dev/null
# 常見:/var/lib/mysql/mysql.sock、/var/run/mysqld/mysqld.sock
# 客戶端指定 -S 參數
mysql -u root -p -S /var/lib/mysql/mysql.sock
mysqladmin -u root -p -S /var/lib/mysql/mysql.sock ping
vim /etc/my.cnf
[mysqld]
socket=/var/lib/mysql/mysql.sock
[client]
socket=/var/lib/mysql/mysql.sock
[mysql]
socket=/var/lib/mysql/mysql.sock
[mysqladmin]
socket=/var/lib/mysql/mysql.sock
重啟服務:systemctl restart mysqld
mysql -u root -p -e "SHOW VARIABLES LIKE 'socket';"
# 應輸出 /var/lib/mysql/mysql.sock
# 設定 /tmp sticky bit(僅擁有者/root 可刪除)
chmod +t /tmp
# 驗證
ls -ld /tmp
# drwxrwxrwt <- 最後一位 t 表示已設定
/tmp/mysql.sock,yum/apt 安裝預設在 /var/lib/mysql/,混用導致不一致