場(chǎng)景

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

排查過(guò)程

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

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

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

[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