Docker mysql failed to start

error log

2018-11-01T07:51:55.214905Z 0 [Warning] "ERROR_FOR_DIVISION_BY_ZERO" mode is removed. Setting this will have no effect.
2018-11-01T07:51:55.215499Z 0 [Warning] "ERROR_FOR_DIVISION_BY_ZERO" mode is removed. Setting this will have no effect.
2018-11-01T07:51:55.215504Z 0 [Warning] "ERROR_FOR_DIVISION_BY_ZERO" mode is removed. Setting this will have no effect.
2018-11-01T07:51:55.216812Z 0 [Note] mysqld (mysqld 5.7.4-m14-log) starting as process 1 ...
2018-11-01T07:51:55.252846Z 0 [Note] Plugin "FEDERATED" is disabled.
2018-11-01T07:51:55.270318Z 0 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-11-01T07:51:55.270353Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-01T07:51:55.270358Z 0 [Note] InnoDB: Uses event mutexes
2018-11-01T07:51:55.270360Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-11-01T07:51:55.270362Z 0 [Note] InnoDB: Using Linux native AIO
2018-11-01T07:51:55.274288Z 0 [Note] InnoDB: Number of pools: 1
2018-11-01T07:51:55.274698Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-11-01T07:51:55.276858Z 0 [Note] InnoDB: Initializing buffer pool, total size = 160.0M, instances = 1
2018-11-01T07:51:55.299342Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-01T07:51:55.346210Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-01T07:51:55.634882Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-11-01T07:51:55.635697Z 0 [Note] InnoDB: Setting file "./ibtmp1" size to 12 MB. Physically writing the file full; Please wait ...
2018-11-01T07:51:55.717649Z 0 [Note] InnoDB: File "./ibtmp1" size is now 12 MB.
2018-11-01T07:51:55.718844Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-11-01T07:51:55.718856Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-11-01T07:51:55.739986Z 0 [Note] InnoDB: Waiting for purge to start
2018-11-01T07:51:55.790813Z 0 [Note] InnoDB: 5.7.4 started; log sequence number 10749552
2018-11-01T07:51:55.843993Z 0 [Note] Server hostname (bind-address): "*"; port: 3306
2018-11-01T07:51:55.844296Z 0 [Note] IPv6 is available.
2018-11-01T07:51:55.844363Z 0 [Note] - "::" resolves to "::";
2018-11-01T07:51:55.844390Z 0 [Note] Server socket created on IP: "::".
2018-11-01T07:51:55.844499Z 0 [ERROR] Can"t start server : Bind on unix socket: No such file or directory
2018-11-01T07:51:55.844610Z 0 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
2018-11-01T07:51:55.844745Z 0 [ERROR] Aborting

2018-11-01T07:51:55.844876Z 0 [Note] Binlog end
2018-11-01T07:51:55.845912Z 0 [Note] Shutting down plugin "partition"
2018-11-01T07:51:55.845979Z 0 [Note] Shutting down plugin "ARCHIVE"
2018-11-01T07:51:55.845998Z 0 [Note] Shutting down plugin "BLACKHOLE"
2018-11-01T07:51:55.846012Z 0 [Note] Shutting down plugin "PERFORMANCE_SCHEMA"
2018-11-01T07:51:55.846134Z 0 [Note] Shutting down plugin "INNODB_SYS_DATAFILES"
2018-11-01T07:51:55.846194Z 0 [Note] Shutting down plugin "INNODB_SYS_TABLESPACES"
2018-11-01T07:51:55.846213Z 0 [Note] Shutting down plugin "INNODB_SYS_FOREIGN_COLS"
2018-11-01T07:51:55.846316Z 0 [Note] Shutting down plugin "INNODB_SYS_FOREIGN"
2018-11-01T07:51:55.846373Z 0 [Note] Shutting down plugin "INNODB_SYS_FIELDS"
2018-11-01T07:51:55.846392Z 0 [Note] Shutting down plugin "INNODB_SYS_COLUMNS"
2018-11-01T07:51:55.846494Z 0 [Note] Shutting down plugin "INNODB_SYS_INDEXES"
2018-11-01T07:51:55.846574Z 0 [Note] Shutting down plugin "INNODB_SYS_TABLESTATS"
2018-11-01T07:51:55.846687Z 0 [Note] Shutting down plugin "INNODB_SYS_TABLES"
2018-11-01T07:51:55.846771Z 0 [Note] Shutting down plugin "INNODB_FT_INDEX_TABLE"
2018-11-01T07:51:55.846847Z 0 [Note] Shutting down plugin "INNODB_FT_INDEX_CACHE"
2018-11-01T07:51:55.846973Z 0 [Note] Shutting down plugin "INNODB_FT_CONFIG"
2018-11-01T07:51:55.847049Z 0 [Note] Shutting down plugin "INNODB_FT_BEING_DELETED"
2018-11-01T07:51:55.847175Z 0 [Note] Shutting down plugin "INNODB_FT_DELETED"
2018-11-01T07:51:55.847251Z 0 [Note] Shutting down plugin "INNODB_FT_DEFAULT_STOPWORD"
2018-11-01T07:51:55.847376Z 0 [Note] Shutting down plugin "INNODB_METRICS"
2018-11-01T07:51:55.847452Z 0 [Note] Shutting down plugin "INNODB_TEMP_TABLE_INFO"
2018-11-01T07:51:55.847578Z 0 [Note] Shutting down plugin "INNODB_BUFFER_POOL_STATS"
2018-11-01T07:51:55.847654Z 0 [Note] Shutting down plugin "INNODB_BUFFER_PAGE_LRU"
2018-11-01T07:51:55.847780Z 0 [Note] Shutting down plugin "INNODB_BUFFER_PAGE"
2018-11-01T07:51:55.847857Z 0 [Note] Shutting down plugin "INNODB_CMP_PER_INDEX_RESET"
2018-11-01T07:51:55.847982Z 0 [Note] Shutting down plugin "INNODB_CMP_PER_INDEX"
2018-11-01T07:51:55.848058Z 0 [Note] Shutting down plugin "INNODB_CMPMEM_RESET"
2018-11-01T07:51:55.848185Z 0 [Note] Shutting down plugin "INNODB_CMPMEM"
2018-11-01T07:51:55.848260Z 0 [Note] Shutting down plugin "INNODB_CMP_RESET"
2018-11-01T07:51:55.848386Z 0 [Note] Shutting down plugin "INNODB_CMP"
2018-11-01T07:51:55.848461Z 0 [Note] Shutting down plugin "INNODB_LOCK_WAITS"
2018-11-01T07:51:55.848587Z 0 [Note] Shutting down plugin "INNODB_LOCKS"
2018-11-01T07:51:55.848663Z 0 [Note] Shutting down plugin "INNODB_TRX"
2018-11-01T07:51:55.848788Z 0 [Note] Shutting down plugin "InnoDB"
2018-11-01T07:51:55.848999Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-11-01T07:51:55.849153Z 0 [Note] InnoDB: Starting shutdown...
2018-11-01T07:51:57.584628Z 0 [Note] InnoDB: Shutdown completed; log sequence number 10749562
2018-11-01T07:51:57.586403Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-11-01T07:51:57.586419Z 0 [Note] Shutting down plugin "CSV"
2018-11-01T07:51:57.586424Z 0 [Note] Shutting down plugin "MEMORY"
2018-11-01T07:51:57.586427Z 0 [Note] Shutting down plugin "MyISAM"
2018-11-01T07:51:57.586433Z 0 [Note] Shutting down plugin "MRG_MYISAM"
2018-11-01T07:51:57.586435Z 0 [Note] Shutting down plugin "sha256_password"
2018-11-01T07:51:57.586437Z 0 [Note] Shutting down plugin "mysql_old_password"
2018-11-01T07:51:57.586439Z 0 [Note] Shutting down plugin "mysql_native_password"
2018-11-01T07:51:57.586545Z 0 [Note] Shutting down plugin "binlog"
2018-11-01T07:51:57.590977Z 0 [Note] mysqld: Shutdown complete

configuration file my.cnf

[mysql]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld]

server-id = 1
default-storage-engine = InnoDB
socket = /var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysql.pid

key-buffer-size = 32M

max-allowed-packet = 16M
max-connect-errors = 1000000
skip-name-resolve
sysdate-is-now = 1
sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
explicit_defaults_for_timestamp=true

datadir = /var/lib/mysql/

log-bin = /var/lib/mysql/mysql-bin
expire-logs-days = 14
sync-binlog = 1

tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 1024
table-open-cache = 250

innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 64M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 160M

-sharplog-error = /var/lib/mysql/mysql-error.log
-sharplog-queries-not-using-indexes = 1
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
Oct.12,2021

has no solution. The image of a different version is normal again

Menu