2018-09-01T07:31:48.174316Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-01T07:31:49.318872Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-09-01T07:31:49.618293Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-09-01T07:31:49.683479Z 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: 16bcea8d-adb9-11e8-a289-000c292b1742.
2018-09-01T07:31:49.685890Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-09-01T07:31:49.686626Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2018-09-01T07:31:54.147188Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-01T07:31:54.149268Z 0 [Note] mysqld (mysqld 5.7.23-0ubuntu0.18.04.1) starting as process 116616 ...
2018-09-01T07:31:54.180655Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-09-01T07:31:54.180682Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-01T07:31:54.180687Z 0 [Note] InnoDB: Uses event mutexes
2018-09-01T07:31:54.180690Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-09-01T07:31:54.180694Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-09-01T07:31:54.180697Z 0 [Note] InnoDB: Using Linux native AIO
2018-09-01T07:31:54.181033Z 0 [Note] InnoDB: Number of pools: 1
2018-09-01T07:31:54.181139Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-09-01T07:31:54.183057Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-09-01T07:31:54.192627Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-09-01T07:31:54.196620Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-09-01T07:31:54.209168Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-01T07:31:54.217650Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-09-01T07:31:54.217713Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-09-01T07:31:54.318218Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-09-01T07:31:54.318952Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-09-01T07:31:54.318965Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-09-01T07:31:54.319338Z 0 [Note] InnoDB: Waiting for purge to start
2018-09-01T07:31:54.370436Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589385
2018-09-01T07:31:54.370685Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-09-01T07:31:54.370776Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-09-01T07:31:54.372172Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180901 13:01:54
2018-09-01T07:31:54.375779Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-09-01T07:31:54.378365Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2018-09-01T07:31:54.385530Z 0 [Note] Event Scheduler: Loaded 0 events
2018-09-01T07:31:54.385802Z 0 [Note] mysqld: ready for connections.
Version: '5.7.23-0ubuntu0.18.04.1'  socket: '/tmp/tmp.yr2ej2F8yk/mysqld.sock'  port: 0  (Ubuntu)
2018-09-01T07:31:54.462776Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-09-01T07:31:54.462798Z 0 [Note] Shutting down slave threads
2018-09-01T07:31:54.462806Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-09-01T07:31:54.462812Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-09-01T07:31:54.462965Z 0 [Note] Binlog end
2018-09-01T07:31:54.463437Z 0 [Note] Shutting down plugin 'auth_socket'
2018-09-01T07:31:54.463449Z 0 [Note] Shutting down plugin 'ngram'
2018-09-01T07:31:54.463452Z 0 [Note] Shutting down plugin 'partition'
2018-09-01T07:31:54.463455Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-09-01T07:31:54.463459Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-09-01T07:31:54.463461Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-09-01T07:31:54.463482Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-09-01T07:31:54.463486Z 0 [Note] Shutting down plugin 'MyISAM'
2018-09-01T07:31:54.463491Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-09-01T07:31:54.463494Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-09-01T07:31:54.463497Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-09-01T07:31:54.463499Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-09-01T07:31:54.463502Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-09-01T07:31:54.463504Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-09-01T07:31:54.463507Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-09-01T07:31:54.463509Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-09-01T07:31:54.463512Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-09-01T07:31:54.463514Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-09-01T07:31:54.463516Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-09-01T07:31:54.463519Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-09-01T07:31:54.463521Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-09-01T07:31:54.463524Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-09-01T07:31:54.463526Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-09-01T07:31:54.463529Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-09-01T07:31:54.463531Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-09-01T07:31:54.463533Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-09-01T07:31:54.463536Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-09-01T07:31:54.463538Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-09-01T07:31:54.463541Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-09-01T07:31:54.463543Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-09-01T07:31:54.463546Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-09-01T07:31:54.463548Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-09-01T07:31:54.463551Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-09-01T07:31:54.463553Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-09-01T07:31:54.463555Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-09-01T07:31:54.463558Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-09-01T07:31:54.463560Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-09-01T07:31:54.463563Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-09-01T07:31:54.463565Z 0 [Note] Shutting down plugin 'InnoDB'
2018-09-01T07:31:54.463641Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-09-01T07:31:54.463749Z 0 [Note] InnoDB: Starting shutdown...
2018-09-01T07:31:54.564360Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-09-01T07:31:54.564624Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180901 13:01:54
2018-09-01T07:31:56.183949Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2589590
2018-09-01T07:31:56.185802Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-09-01T07:31:56.185816Z 0 [Note] Shutting down plugin 'MEMORY'
2018-09-01T07:31:56.185822Z 0 [Note] Shutting down plugin 'CSV'
2018-09-01T07:31:56.185826Z 0 [Note] Shutting down plugin 'sha256_password'
2018-09-01T07:31:56.185829Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-09-01T07:31:56.186011Z 0 [Note] Shutting down plugin 'binlog'
2018-09-01T07:31:56.186373Z 0 [Note] mysqld: Shutdown complete

2018-09-01T07:31:57.068199Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-01T07:31:57.069733Z 0 [Note] mysqld (mysqld 5.7.23-0ubuntu0.18.04.1) starting as process 116666 ...
2018-09-01T07:31:57.074798Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-09-01T07:31:57.074815Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-01T07:31:57.074820Z 0 [Note] InnoDB: Uses event mutexes
2018-09-01T07:31:57.074823Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-09-01T07:31:57.074844Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-09-01T07:31:57.074852Z 0 [Note] InnoDB: Using Linux native AIO
2018-09-01T07:31:57.075068Z 0 [Note] InnoDB: Number of pools: 1
2018-09-01T07:31:57.075157Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-09-01T07:31:57.076807Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-09-01T07:31:57.084341Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-09-01T07:31:57.086522Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-09-01T07:31:57.098689Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-01T07:31:57.108724Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-09-01T07:31:57.108783Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-09-01T07:31:57.173452Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-09-01T07:31:57.174146Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-09-01T07:31:57.174161Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-09-01T07:31:57.174863Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589590
2018-09-01T07:31:57.175161Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-09-01T07:31:57.176233Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-09-01T07:31:57.177867Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180901 13:01:57
2018-09-01T07:31:57.179459Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-09-01T07:31:57.179473Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-09-01T07:31:57.179486Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-09-01T07:31:57.179506Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-09-01T07:31:57.179519Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2018-09-01T07:31:57.179523Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-09-01T07:31:57.179547Z 0 [ERROR] Aborting

2018-09-01T07:31:57.179554Z 0 [Note] Binlog end
2018-09-01T07:31:57.179591Z 0 [Note] Shutting down plugin 'auth_socket'
2018-09-01T07:31:57.179598Z 0 [Note] Shutting down plugin 'ngram'
2018-09-01T07:31:57.179601Z 0 [Note] Shutting down plugin 'partition'
2018-09-01T07:31:57.179604Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-09-01T07:31:57.179607Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-09-01T07:31:57.179610Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-09-01T07:31:57.179641Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-09-01T07:31:57.179644Z 0 [Note] Shutting down plugin 'MyISAM'
2018-09-01T07:31:57.179653Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-09-01T07:31:57.179656Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-09-01T07:31:57.179658Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-09-01T07:31:57.179661Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-09-01T07:31:57.179663Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-09-01T07:31:57.179666Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-09-01T07:31:57.179669Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-09-01T07:31:57.179671Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-09-01T07:31:57.179674Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-09-01T07:31:57.179683Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-09-01T07:31:57.179686Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-09-01T07:31:57.179689Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-09-01T07:31:57.179691Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-09-01T07:31:57.179694Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-09-01T07:31:57.179696Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-09-01T07:31:57.179698Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-09-01T07:31:57.179701Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-09-01T07:31:57.179703Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-09-01T07:31:57.179706Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-09-01T07:31:57.179708Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-09-01T07:31:57.179710Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-09-01T07:31:57.179713Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-09-01T07:31:57.179715Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-09-01T07:31:57.179718Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-09-01T07:31:57.179720Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-09-01T07:31:57.179723Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-09-01T07:31:57.179725Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-09-01T07:31:57.179727Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-09-01T07:31:57.179730Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-09-01T07:31:57.179732Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-09-01T07:31:57.179735Z 0 [Note] Shutting down plugin 'InnoDB'
2018-09-01T07:31:57.179861Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-09-01T07:31:57.180014Z 0 [Note] InnoDB: Starting shutdown...
2018-09-01T07:31:57.280857Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-09-01T07:31:57.281134Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180901 13:01:57
2018-09-01T07:31:58.796993Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2589609
2018-09-01T07:31:58.798751Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-09-01T07:31:58.798773Z 0 [Note] Shutting down plugin 'MEMORY'
2018-09-01T07:31:58.798778Z 0 [Note] Shutting down plugin 'CSV'
2018-09-01T07:31:58.798784Z 0 [Note] Shutting down plugin 'sha256_password'
2018-09-01T07:31:58.798786Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-09-01T07:31:58.798933Z 0 [Note] Shutting down plugin 'binlog'
2018-09-01T07:31:58.799139Z 0 [Note] mysqld: Shutdown complete