MySQLBindonunixsocket:Add

場(chǎng)景

創(chuàng)新互聯(lián)專注于宿城企業(yè)網(wǎng)站建設(shè),響應(yīng)式網(wǎng)站建設(shè),成都商城網(wǎng)站開發(fā)。宿城網(wǎng)站建設(shè)公司,為宿城等地區(qū)提供建站服務(wù)。全流程定制網(wǎng)站建設(shè)，專業(yè)設(shè)計(jì)，全程項(xiàng)目跟蹤，創(chuàng)新互聯(lián)專業(yè)和態(tài)度為您提供的服務(wù)

[root@localhost bin]# ./MySQLd
2020-01-15 17:52:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-01-15 17:52:02 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2020-01-15 17:52:02 0 [Note] ./mysqld (mysqld 5.6.44) starting as process 90367 ...
2020-01-15 17:52:02 90367 [Note] Plugin 'FEDERATED' is disabled.
2020-01-15 17:52:02 90367 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-01-15 17:52:02 90367 [Note] InnoDB: The InnoDB memory heap is disabled
2020-01-15 17:52:02 90367 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-01-15 17:52:02 90367 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-01-15 17:52:02 90367 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-01-15 17:52:02 90367 [Note] InnoDB: Using Linux native AIO
2020-01-15 17:52:02 90367 [Note] InnoDB: Not using CPU crc32 instructions
2020-01-15 17:52:02 90367 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-01-15 17:52:02 90367 [Note] InnoDB: Completed initialization of buffer pool
2020-01-15 17:52:02 90367 [Note] InnoDB: Highest supported file format is Barracuda.
2020-01-15 17:52:02 90367 [Note] InnoDB: 128 rollback segment(s) are active.
2020-01-15 17:52:02 90367 [Note] InnoDB: Waiting for purge to start
2020-01-15 17:52:02 90367 [Note] InnoDB: 5.6.44 started; log sequence number 18755961
2020-01-15 17:52:02 90367 [Note] Server hostname (bind-address): '*'; port: 3306
2020-01-15 17:52:02 90367 [Note] IPv6 is available.
2020-01-15 17:52:02 90367 [Note]?? - '::' resolves to '::';
2020-01-15 17:52:02 90367 [Note] Server socket created on IP: '::'.
2020-01-15 17:52:02 90367 [ERROR] Can't start server : Bind on unix socket: Address already in use
2020-01-15 17:52:02 90367 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
2020-01-15 17:52:02 90367 [ERROR] Aborting

排查過程

1）管道文件已經(jīng)存在

2020-01-15 17:52:02 90367 [ERROR] Can't start server : Bind on unix socket: Address already in use
2020-01-15 17:52:02 90367 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?

2）查看文件屬性以及查看進(jìn)程占用

[root@localhost tmp]# file mysqld.sock
mysqld.sock: socket

[root@localhost tmp]# fuser /tmp/mysql.sock

沒有發(fā)現(xiàn)任何進(jìn)程占用，說明該文件不是由mysqld進(jìn)程創(chuàng)建的，并且沒有任何的服務(wù)占用該管道文件，該管道文件一般用于本地的mysql服務(wù)器和客戶端通信的通道。默認(rèn)情況下，mysql主進(jìn)程在啟動(dòng)的時(shí)候創(chuàng)建該文件，退出的時(shí)候，會(huì)刪除該文件，通過刪除該文件，解決上面的問題。

3）啟動(dòng)mysql服務(wù)，查看占用過程

[root@localhost tmp]# fuser /tmp/mysql.sock
/tmp/mysqld.sock:??? 76533
[root@localhost tmp]# lsof /tmp/mysql.sock
COMMAND?? PID? USER?? FD?? TYPE???????????? DEVICE SIZE/OFF??? NODE NAME
mysqld? 76533 mysql?? 22u? unix 0x00000000f901123c????? 0t0 8234599 /tmp/mysql.sock

本文題目：MySQLBindonunixsocket:Add
本文來源：http://muchs.cn/article42/ihdshc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供微信小程序、企業(yè)網(wǎng)站制作、網(wǎng)站改版、網(wǎng)頁(yè)設(shè)計(jì)公司、App開發(fā)、面包屑導(dǎo)航

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)