Shulou(Shulou.com)06/01 Report--

Scene

[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: 128rollback 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

Investigation process

1) the pipeline file already exists

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) View file properties and view process occupancy

[root@localhost tmp] # file mysqld.sock

Mysqld.sock: socket

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

No process occupancy was found, indicating that the file was not created by the mysqld process, and that no service occupies the pipe file, which is typically used as a channel for local mysql server and client communication. By default, the MySQL main process creates the file when it starts, deletes the file when it exits, and solves the above problem by deleting the file.

3) start the mysql service to view the occupancy process

[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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.