docker-compose up

Recreating tmp_db_1 ... done
Attaching to tmp_db_1
db_1  | Initializing database
db_1  | 2020-02-17T02:42:39.099611Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1  | 2020-02-17T02:42:40.000580Z 0 [Warning] InnoDB: New log files created, LSN=45790
db_1  | 2020-02-17T02:42:40.121895Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
db_1  | 2020-02-17T02:42:40.204983Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2a3b1552-512f-11ea-88f6-0242ac1d0002.
db_1  | 2020-02-17T02:42:40.210694Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
db_1  | 2020-02-17T02:42:40.215070Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
db_1  | Database initialized
db_1  | Initializing certificates
db_1  | Generating a RSA private key
db_1  | ...+++++
db_1  | ...........................................................+++++
db_1  | unable to write 'random state'
db_1  | writing new private key to 'ca-key.pem'
db_1  | -----
db_1  | Generating a RSA private key
db_1  | ..................................................................................................................................................+++++
db_1  | ......................................................+++++
db_1  | unable to write 'random state'
db_1  | writing new private key to 'server-key.pem'
db_1  | -----
db_1  | Generating a RSA private key
db_1  | ...+++++
db_1  | ..............................+++++
db_1  | unable to write 'random state'
db_1  | writing new private key to 'client-key.pem'
db_1  | -----
db_1  | Certificates initialized
db_1  | MySQL init process in progress...
db_1  | 2020-02-17T02:42:44.298918Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1  | 2020-02-17T02:42:44.307313Z 0 [Note] mysqld (mysqld 5.7.26) starting as process 91 ...
db_1  | 2020-02-17T02:42:44.316263Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1  | 2020-02-17T02:42:44.316392Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1  | 2020-02-17T02:42:44.316423Z 0 [Note] InnoDB: Uses event mutexes
db_1  | 2020-02-17T02:42:44.316468Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1  | 2020-02-17T02:42:44.316539Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
db_1  | 2020-02-17T02:42:44.316580Z 0 [Note] InnoDB: Using Linux native AIO
db_1  | 2020-02-17T02:42:44.317838Z 0 [Note] InnoDB: Number of pools: 1
db_1  | 2020-02-17T02:42:44.318549Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1  | 2020-02-17T02:42:44.326991Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1  | 2020-02-17T02:42:44.362916Z 0 [Note] InnoDB: Completed initialization of buffer pool
db_1  | 2020-02-17T02:42:44.374250Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1  | 2020-02-17T02:42:44.394553Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
db_1  | 2020-02-17T02:42:44.424515Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1  | 2020-02-17T02:42:44.424987Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1  | 2020-02-17T02:42:44.507424Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1  | 2020-02-17T02:42:44.509859Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
db_1  | 2020-02-17T02:42:44.509997Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
db_1  | 2020-02-17T02:42:44.511571Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2524985
db_1  | 2020-02-17T02:42:44.512819Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1  | 2020-02-17T02:42:44.513305Z 0 [Note] Plugin 'FEDERATED' is disabled.
db_1  | 2020-02-17T02:42:44.518528Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200217  2:42:44
db_1  | 2020-02-17T02:42:44.540700Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
db_1  | 2020-02-17T02:42:44.544929Z 0 [Warning] CA certificate ca.pem is self signed.
db_1  | 2020-02-17T02:42:44.561724Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
db_1  | 2020-02-17T02:42:44.584666Z 0 [Note] Event Scheduler: Loaded 0 events
db_1  | 2020-02-17T02:42:44.585140Z 0 [Note] mysqld: ready for connections.
db_1  | Version: '5.7.26'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
db_1  | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
db_1  | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
db_1  | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
db_1  | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
db_1  |
db_1  | 2020-02-17T02:42:49.157435Z 0 [Note] Giving 0 client threads a chance to die gracefully
db_1  | 2020-02-17T02:42:49.157517Z 0 [Note] Shutting down slave threads
db_1  | 2020-02-17T02:42:49.157534Z 0 [Note] Forcefully disconnecting 0 remaining clients
db_1  | 2020-02-17T02:42:49.157556Z 0 [Note] Event Scheduler: Purging the queue. 0 events
db_1  | 2020-02-17T02:42:49.158442Z 0 [Note] Binlog end
db_1  | 2020-02-17T02:42:49.159628Z 0 [Note] Shutting down plugin 'ngram'
db_1  | 2020-02-17T02:42:49.159695Z 0 [Note] Shutting down plugin 'partition'
db_1  | 2020-02-17T02:42:49.159709Z 0 [Note] Shutting down plugin 'BLACKHOLE'
db_1  | 2020-02-17T02:42:49.159716Z 0 [Note] Shutting down plugin 'ARCHIVE'
db_1  | 2020-02-17T02:42:49.159727Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
db_1  | 2020-02-17T02:42:49.159768Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
db_1  | 2020-02-17T02:42:49.159784Z 0 [Note] Shutting down plugin 'MyISAM'
db_1  | 2020-02-17T02:42:49.159811Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
db_1  | 2020-02-17T02:42:49.159822Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
db_1  | 2020-02-17T02:42:49.159829Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
db_1  | 2020-02-17T02:42:49.159839Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
db_1  | 2020-02-17T02:42:49.159849Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
db_1  | 2020-02-17T02:42:49.159859Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
db_1  | 2020-02-17T02:42:49.159868Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
db_1  | 2020-02-17T02:42:49.159878Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
db_1  | 2020-02-17T02:42:49.159892Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
db_1  | 2020-02-17T02:42:49.159908Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
db_1  | 2020-02-17T02:42:49.159917Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
db_1  | 2020-02-17T02:42:49.159927Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
db_1  | 2020-02-17T02:42:49.159941Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
db_1  | 2020-02-17T02:42:49.159954Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
db_1  | 2020-02-17T02:42:49.159963Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
db_1  | 2020-02-17T02:42:49.159974Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
db_1  | 2020-02-17T02:42:49.159995Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
db_1  | 2020-02-17T02:42:49.160003Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
db_1  | 2020-02-17T02:42:49.160013Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
db_1  | 2020-02-17T02:42:49.160021Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
db_1  | 2020-02-17T02:42:49.160032Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
db_1  | 2020-02-17T02:42:49.160040Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
db_1  | 2020-02-17T02:42:49.160050Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
db_1  | 2020-02-17T02:42:49.160061Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
db_1  | 2020-02-17T02:42:49.160070Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
db_1  | 2020-02-17T02:42:49.160079Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
db_1  | 2020-02-17T02:42:49.160089Z 0 [Note] Shutting down plugin 'INNODB_CMP'
db_1  | 2020-02-17T02:42:49.160103Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
db_1  | 2020-02-17T02:42:49.160117Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
db_1  | 2020-02-17T02:42:49.160127Z 0 [Note] Shutting down plugin 'INNODB_TRX'
db_1  | 2020-02-17T02:42:49.160134Z 0 [Note] Shutting down plugin 'InnoDB'
db_1  | 2020-02-17T02:42:49.161417Z 0 [Note] InnoDB: FTS optimize thread exiting.
db_1  | 2020-02-17T02:42:49.162629Z 0 [Note] InnoDB: Starting shutdown...
db_1  | 2020-02-17T02:42:49.265075Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
db_1  | 2020-02-17T02:42:49.265793Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200217  2:42:49
db_1  | 2020-02-17T02:42:50.392844Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12363846
db_1  | 2020-02-17T02:42:50.397565Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db_1  | 2020-02-17T02:42:50.397710Z 0 [Note] Shutting down plugin 'MEMORY'
db_1  | 2020-02-17T02:42:50.397740Z 0 [Note] Shutting down plugin 'CSV'
db_1  | 2020-02-17T02:42:50.397763Z 0 [Note] Shutting down plugin 'sha256_password'
db_1  | 2020-02-17T02:42:50.397787Z 0 [Note] Shutting down plugin 'mysql_native_password'
db_1  | 2020-02-17T02:42:50.398452Z 0 [Note] Shutting down plugin 'binlog'
db_1  | 2020-02-17T02:42:50.405478Z 0 [Note] mysqld: Shutdown complete
db_1  |
db_1  |
db_1  | MySQL init process done. Ready for start up.
db_1  |
db_1  | 2020-02-17T02:42:50.638137Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1  | 2020-02-17T02:42:50.639759Z 0 [Note] mysqld (mysqld 5.7.26) starting as process 1 ...
db_1  | 2020-02-17T02:42:50.644176Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1  | 2020-02-17T02:42:50.644237Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1  | 2020-02-17T02:42:50.644252Z 0 [Note] InnoDB: Uses event mutexes
db_1  | 2020-02-17T02:42:50.644266Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1  | 2020-02-17T02:42:50.644275Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
db_1  | 2020-02-17T02:42:50.644281Z 0 [Note] InnoDB: Using Linux native AIO
db_1  | 2020-02-17T02:42:50.644629Z 0 [Note] InnoDB: Number of pools: 1
db_1  | 2020-02-17T02:42:50.644990Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1  | 2020-02-17T02:42:50.648370Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1  | 2020-02-17T02:42:50.658796Z 0 [Note] InnoDB: Completed initialization of buffer pool
db_1  | 2020-02-17T02:42:50.661766Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1  | 2020-02-17T02:42:50.674825Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
db_1  | 2020-02-17T02:42:50.689110Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1  | 2020-02-17T02:42:50.689271Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1  | 2020-02-17T02:42:50.720971Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1  | 2020-02-17T02:42:50.722640Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
db_1  | 2020-02-17T02:42:50.722713Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
db_1  | 2020-02-17T02:42:50.724031Z 0 [Note] InnoDB: Waiting for purge to start
db_1  | 2020-02-17T02:42:50.774867Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 12363846
db_1  | 2020-02-17T02:42:50.775691Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1  | 2020-02-17T02:42:50.776473Z 0 [Note] Plugin 'FEDERATED' is disabled.
db_1  | 2020-02-17T02:42:50.780818Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200217  2:42:50
db_1  | 2020-02-17T02:42:50.784042Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
db_1  | 2020-02-17T02:42:50.784707Z 0 [Warning] CA certificate ca.pem is self signed.
db_1  | 2020-02-17T02:42:50.788220Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
db_1  | 2020-02-17T02:42:50.792233Z 0 [Note] IPv6 is available.
db_1  | 2020-02-17T02:42:50.793627Z 0 [Note]   - '::' resolves to '::';
db_1  | 2020-02-17T02:42:50.793786Z 0 [Note] Server socket created on IP: '::'.
db_1  | 2020-02-17T02:42:50.797681Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
db_1  | 2020-02-17T02:42:50.813018Z 0 [Note] Event Scheduler: Loaded 0 events
db_1  | 2020-02-17T02:42:50.813989Z 0 [Note] mysqld: ready for connections.
db_1  | Version: '5.7.26'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)

docker-compose.yml

version: '3'

services:
  db:
    image: mysql:5.7
    environment:
      MYSQL_ALLOW_EMPTY_PASSWORD: 1