Hello there,
I am totally new at this so i think there a tons of people who know an answer to this question.
I just installed Local.
I created a new site on Local. (no live existing site though)
Now i press “view site” , in order to get started building the site in wordpress.
However, i got the " this page is not reachable error" in Microsoft Edge.
I got the same message when clicking " Admin".
error log PHP: [13-Feb-2019 08:56:10 UTC] PHP Warning: Error while sending QUERY packet. PID=625 in /app/public/wp-includes/wp-db.php on line 1924.
And a huge error log on Mysql:
2019-02-13T08:52:33.640502Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-02-13T08:52:33.641082Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23) starting as process 31 …
2019-02-13T08:52:33.655203Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-02-13T08:52:33.655760Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-02-13T08:52:33.656234Z 0 [Note] InnoDB: Uses event mutexes
2019-02-13T08:52:33.656735Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-02-13T08:52:33.657240Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-02-13T08:52:33.657453Z 0 [Note] InnoDB: Using Linux native AIO
2019-02-13T08:52:33.658291Z 0 [Note] InnoDB: Number of pools: 1
2019-02-13T08:52:33.658632Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-02-13T08:52:33.661106Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M
2019-02-13T08:52:33.664614Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-02-13T08:52:33.671353Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-02-13T08:52:33.683665Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-02-13T08:52:33.690819Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2588963
2019-02-13T08:52:33.691113Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2591784
2019-02-13T08:52:33.691929Z 0 [Note] InnoDB: Database was not shutdown normally!
2019-02-13T08:52:33.692261Z 0 [Note] InnoDB: Starting crash recovery.
2019-02-13T08:52:34.079021Z 0 [Note] InnoDB: Starting an apply batch of log records to the database…
InnoDB: Progress in percent: 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
2019-02-13T08:52:34.614991Z 0 [Note] InnoDB: Apply batch completed
2019-02-13T08:52:34.717362Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2019-02-13T08:52:34.717740Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-02-13T08:52:34.717978Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2019-02-13T08:52:34.745702Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2019-02-13T08:52:34.746769Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-02-13T08:52:34.746980Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-02-13T08:52:34.747938Z 0 [Note] InnoDB: Waiting for purge to start
2019-02-13T08:52:34.799035Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2591784
2019-02-13T08:52:34.810248Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2019-02-13T08:52:34.811752Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2019-02-13T08:52:34.812010Z 0 [Note] Server hostname (bind-address): ‘'; port: 3306
2019-02-13T08:52:34.812540Z 0 [Note] IPv6 is available.
2019-02-13T08:52:34.813011Z 0 [Note] - ‘::’ resolves to ‘::’;
2019-02-13T08:52:34.813509Z 0 [Note] Server socket created on IP: ‘::’.
2019-02-13T08:52:34.815063Z 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.
2019-02-13T08:52:34.832935Z 0 [ERROR] /usr/sbin/mysqld: Table ‘./mysql/user’ is marked as crashed and should be repaired
2019-02-13T08:52:34.833067Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-02-13T08:52:34.841918Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190213 8:52:34
2019-02-13T08:52:34.842186Z 0 [Warning] Checking table: ‘./mysql/user’
2019-02-13T08:52:34.842543Z 0 [ERROR] 1 client is using or hasn’t closed the table properly
2019-02-13T08:52:34.843673Z 0 [Warning] ‘user’ entry ‘root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.844047Z 0 [Warning] ‘user’ entry ‘mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.844288Z 0 [Warning] ‘user’ entry ‘mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.844476Z 0 [Warning] ‘db’ entry ‘performance_schema mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.844615Z 0 [Warning] ‘db’ entry ‘sys mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.844819Z 0 [Warning] ‘proxies_priv’ entry ‘@ root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.847108Z 0 [Warning] ‘tables_priv’ entry ‘user mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.850110Z 0 [Warning] ‘tables_priv’ entry ‘sys_config mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:52:34.859750Z 0 [Note] Event Scheduler: Loaded 0 events
2019-02-13T08:52:34.880233Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.7.23’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
2019-02-13T08:53:06.958833Z 4 [ERROR] /usr/sbin/mysqld: Table ‘./mysql/proc’ is marked as crashed and should be repaired
2019-02-13T08:53:06.959171Z 4 [Warning] Checking table: ‘./mysql/proc’
2019-02-13T08:53:06.970144Z 6 [Warning] ‘user’ entry ‘root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:53:06.970402Z 6 [Warning] ‘user’ entry ‘mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:53:06.970524Z 6 [Warning] ‘user’ entry ‘mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:53:06.970682Z 6 [Warning] ‘db’ entry ‘performance_schema mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:53:06.970812Z 6 [Warning] ‘db’ entry ‘sys mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:53:06.970950Z 6 [Warning] ‘proxies_priv’ entry ‘@ root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:53:06.971258Z 6 [Warning] ‘tables_priv’ entry ‘user mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:53:06.971401Z 6 [Warning] ‘tables_priv’ entry ‘sys_config mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:10.854678Z 0 [Note] Giving 1 client threads a chance to die gracefully
2019-02-13T08:56:10.854998Z 0 [Note] Shutting down slave threads
2019-02-13T08:56:12.855824Z 0 [Note] Forcefully disconnecting 0 remaining clients
2019-02-13T08:56:12.856087Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2019-02-13T08:56:12.856345Z 0 [Note] Binlog end
2019-02-13T08:56:12.857739Z 0 [Note] Shutting down plugin ‘ngram’
2019-02-13T08:56:12.857938Z 0 [Note] Shutting down plugin ‘partition’
2019-02-13T08:56:12.858106Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2019-02-13T08:56:12.858274Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2019-02-13T08:56:12.858442Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2019-02-13T08:56:12.858619Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2019-02-13T08:56:12.858764Z 0 [Note] Shutting down plugin ‘MyISAM’
2019-02-13T08:56:12.858856Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2019-02-13T08:56:12.858995Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2019-02-13T08:56:12.859146Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2019-02-13T08:56:12.859249Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2019-02-13T08:56:12.859354Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2019-02-13T08:56:12.859443Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2019-02-13T08:56:12.859526Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2019-02-13T08:56:12.859611Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2019-02-13T08:56:12.859690Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2019-02-13T08:56:12.859759Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2019-02-13T08:56:12.859826Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2019-02-13T08:56:12.859927Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2019-02-13T08:56:12.859998Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2019-02-13T08:56:12.860066Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2019-02-13T08:56:12.860132Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2019-02-13T08:56:12.860199Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2019-02-13T08:56:12.860266Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2019-02-13T08:56:12.860333Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2019-02-13T08:56:12.860399Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2019-02-13T08:56:12.860466Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2019-02-13T08:56:12.860533Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2019-02-13T08:56:12.860601Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2019-02-13T08:56:12.860667Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2019-02-13T08:56:12.860734Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2019-02-13T08:56:12.860801Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2019-02-13T08:56:12.860867Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2019-02-13T08:56:12.860933Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2019-02-13T08:56:12.861000Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2019-02-13T08:56:12.861067Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2019-02-13T08:56:12.861133Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2019-02-13T08:56:12.861200Z 0 [Note] Shutting down plugin ‘InnoDB’
2019-02-13T08:56:12.861377Z 0 [Note] InnoDB: FTS optimize thread exiting.
2019-02-13T08:56:12.861617Z 0 [Note] InnoDB: Starting shutdown…
2019-02-13T08:56:12.962474Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2019-02-13T08:56:12.963371Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190213 8:56:12
2019-02-13T08:56:22.860685Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-02-13T08:56:22.863602Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23) starting as process 74 …
2019-02-13T08:56:22.873870Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-02-13T08:56:22.874387Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-02-13T08:56:22.874878Z 0 [Note] InnoDB: Uses event mutexes
2019-02-13T08:56:22.875373Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-02-13T08:56:22.875893Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-02-13T08:56:22.876378Z 0 [Note] InnoDB: Using Linux native AIO
2019-02-13T08:56:22.877087Z 0 [Note] InnoDB: Number of pools: 1
2019-02-13T08:56:22.877464Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-02-13T08:56:22.879266Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M
2019-02-13T08:56:22.881293Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-02-13T08:56:22.891300Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-02-13T08:56:22.903039Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-02-13T08:56:22.903882Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3402921
2019-02-13T08:56:22.904417Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3402930
2019-02-13T08:56:22.904933Z 0 [Note] InnoDB: Database was not shutdown normally!
2019-02-13T08:56:22.905392Z 0 [Note] InnoDB: Starting crash recovery.
2019-02-13T08:56:22.925106Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2019-02-13T08:56:22.925446Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-02-13T08:56:22.925968Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2019-02-13T08:56:22.952669Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2019-02-13T08:56:22.953650Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-02-13T08:56:22.954020Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-02-13T08:56:22.955001Z 0 [Note] InnoDB: Waiting for purge to start
2019-02-13T08:56:23.006102Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 3402930
2019-02-13T08:56:23.006846Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2019-02-13T08:56:23.008284Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2019-02-13T08:56:23.008555Z 0 [Note] Server hostname (bind-address): '’; port: 3306
2019-02-13T08:56:23.009101Z 0 [Note] IPv6 is available.
2019-02-13T08:56:23.009574Z 0 [Note] - ‘::’ resolves to ‘::’;
2019-02-13T08:56:23.010083Z 0 [Note] Server socket created on IP: ‘::’.
2019-02-13T08:56:23.010788Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-02-13T08:56:23.011392Z 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.
2019-02-13T08:56:23.021119Z 0 [Warning] ‘user’ entry ‘root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.021609Z 0 [Warning] ‘user’ entry ‘mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.022078Z 0 [Warning] ‘user’ entry ‘mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.022625Z 0 [Warning] ‘db’ entry ‘performance_schema mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.023175Z 0 [Warning] ‘db’ entry ‘sys mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.023574Z 0 [Warning] ‘proxies_priv’ entry ‘@ root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.025278Z 0 [Warning] ‘tables_priv’ entry ‘user mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.021324Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190213 8:56:23
2019-02-13T08:56:23.025612Z 0 [Warning] ‘tables_priv’ entry ‘sys_config mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T08:56:23.042932Z 0 [Note] Event Scheduler: Loaded 0 events
2019-02-13T08:56:23.049741Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.7.23’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
2019-02-13T09:30:58.226309Z 0 [Note] Giving 0 client threads a chance to die gracefully
2019-02-13T09:30:58.227007Z 0 [Note] Shutting down slave threads
2019-02-13T09:30:58.227940Z 0 [Note] Forcefully disconnecting 0 remaining clients
2019-02-13T09:30:58.228894Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2019-02-13T09:30:58.229994Z 0 [Note] Binlog end
2019-02-13T09:30:58.230703Z 0 [Note] Shutting down plugin ‘ngram’
2019-02-13T09:30:58.230850Z 0 [Note] Shutting down plugin ‘partition’
2019-02-13T09:30:58.231832Z 0 [Note] Shutting down plugin ‘BLACKHOLE’
2019-02-13T09:30:58.232443Z 0 [Note] Shutting down plugin ‘ARCHIVE’
2019-02-13T09:30:58.232810Z 0 [Note] Shutting down plugin ‘PERFORMANCE_SCHEMA’
2019-02-13T09:30:58.233844Z 0 [Note] Shutting down plugin ‘MRG_MYISAM’
2019-02-13T09:30:58.234266Z 0 [Note] Shutting down plugin ‘MyISAM’
2019-02-13T09:30:58.234583Z 0 [Note] Shutting down plugin ‘INNODB_SYS_VIRTUAL’
2019-02-13T09:30:58.234724Z 0 [Note] Shutting down plugin ‘INNODB_SYS_DATAFILES’
2019-02-13T09:30:58.235740Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESPACES’
2019-02-13T09:30:58.236689Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN_COLS’
2019-02-13T09:30:58.237676Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FOREIGN’
2019-02-13T09:30:58.238535Z 0 [Note] Shutting down plugin ‘INNODB_SYS_FIELDS’
2019-02-13T09:30:58.238810Z 0 [Note] Shutting down plugin ‘INNODB_SYS_COLUMNS’
2019-02-13T09:30:58.239113Z 0 [Note] Shutting down plugin ‘INNODB_SYS_INDEXES’
2019-02-13T09:30:58.239233Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLESTATS’
2019-02-13T09:30:58.239802Z 0 [Note] Shutting down plugin ‘INNODB_SYS_TABLES’
2019-02-13T09:30:58.240126Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_TABLE’
2019-02-13T09:30:58.240407Z 0 [Note] Shutting down plugin ‘INNODB_FT_INDEX_CACHE’
2019-02-13T09:30:58.241300Z 0 [Note] Shutting down plugin ‘INNODB_FT_CONFIG’
2019-02-13T09:30:58.242553Z 0 [Note] Shutting down plugin ‘INNODB_FT_BEING_DELETED’
2019-02-13T09:30:58.243098Z 0 [Note] Shutting down plugin ‘INNODB_FT_DELETED’
2019-02-13T09:30:58.243256Z 0 [Note] Shutting down plugin ‘INNODB_FT_DEFAULT_STOPWORD’
2019-02-13T09:30:58.243422Z 0 [Note] Shutting down plugin ‘INNODB_METRICS’
2019-02-13T09:30:58.243547Z 0 [Note] Shutting down plugin ‘INNODB_TEMP_TABLE_INFO’
2019-02-13T09:30:58.243700Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_POOL_STATS’
2019-02-13T09:30:58.244020Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE_LRU’
2019-02-13T09:30:58.244403Z 0 [Note] Shutting down plugin ‘INNODB_BUFFER_PAGE’
2019-02-13T09:30:58.244530Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX_RESET’
2019-02-13T09:30:58.244908Z 0 [Note] Shutting down plugin ‘INNODB_CMP_PER_INDEX’
2019-02-13T09:30:58.245040Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM_RESET’
2019-02-13T09:30:58.245210Z 0 [Note] Shutting down plugin ‘INNODB_CMPMEM’
2019-02-13T09:30:58.245310Z 0 [Note] Shutting down plugin ‘INNODB_CMP_RESET’
2019-02-13T09:30:58.245418Z 0 [Note] Shutting down plugin ‘INNODB_CMP’
2019-02-13T09:30:58.245527Z 0 [Note] Shutting down plugin ‘INNODB_LOCK_WAITS’
2019-02-13T09:30:58.245598Z 0 [Note] Shutting down plugin ‘INNODB_LOCKS’
2019-02-13T09:30:58.245682Z 0 [Note] Shutting down plugin ‘INNODB_TRX’
2019-02-13T09:30:58.245752Z 0 [Note] Shutting down plugin ‘InnoDB’
2019-02-13T09:30:58.245950Z 0 [Note] InnoDB: FTS optimize thread exiting.
2019-02-13T09:30:58.246158Z 0 [Note] InnoDB: Starting shutdown…
2019-02-13T09:30:58.346795Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2019-02-13T09:30:58.347526Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190213 9:30:58
2019-02-13T09:30:59.554002Z 0 [Note] InnoDB: Shutdown completed; log sequence number 3404206
2019-02-13T09:30:59.556555Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2019-02-13T09:30:59.556685Z 0 [Note] Shutting down plugin ‘MEMORY’
2019-02-13T09:30:59.556802Z 0 [Note] Shutting down plugin ‘CSV’
2019-02-13T09:30:59.556903Z 0 [Note] Shutting down plugin ‘sha256_password’
2019-02-13T09:30:59.556987Z 0 [Note] Shutting down plugin ‘mysql_native_password’
2019-02-13T09:30:59.557336Z 0 [Note] Shutting down plugin ‘binlog’
2019-02-13T09:30:59.558219Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2019-02-13T09:33:57.948436Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-02-13T09:33:57.952790Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23) starting as process 75 …
2019-02-13T09:33:58.006807Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-02-13T09:33:58.007752Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-02-13T09:33:58.008718Z 0 [Note] InnoDB: Uses event mutexes
2019-02-13T09:33:58.009694Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-02-13T09:33:58.010671Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-02-13T09:33:58.011643Z 0 [Note] InnoDB: Using Linux native AIO
2019-02-13T09:33:58.017113Z 0 [Note] InnoDB: Number of pools: 1
2019-02-13T09:33:58.023481Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-02-13T09:33:58.027851Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M
2019-02-13T09:33:58.031978Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-02-13T09:33:58.037465Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-02-13T09:33:58.063807Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-02-13T09:33:58.114869Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-02-13T09:33:58.115199Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2019-02-13T09:33:58.149478Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2019-02-13T09:33:58.150769Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-02-13T09:33:58.151206Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-02-13T09:33:58.152469Z 0 [Note] InnoDB: Waiting for purge to start
2019-02-13T09:33:58.203972Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 3404206
2019-02-13T09:33:58.208372Z 0 [Note] Plugin ‘FEDERATED’ is disabled.
2019-02-13T09:33:58.208558Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-02-13T09:33:58.234688Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2019-02-13T09:33:58.234907Z 0 [Note] Server hostname (bind-address): ‘*’; port: 3306
2019-02-13T09:33:58.236127Z 0 [Note] IPv6 is available.
2019-02-13T09:33:58.236719Z 0 [Note] - ‘::’ resolves to ‘::’;
2019-02-13T09:33:58.236866Z 0 [Note] Server socket created on IP: ‘::’.
2019-02-13T09:33:58.239493Z 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.
2019-02-13T09:33:58.244500Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190213 9:33:58
2019-02-13T09:33:58.248003Z 0 [Warning] ‘user’ entry ‘root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.248311Z 0 [Warning] ‘user’ entry ‘mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.248958Z 0 [Warning] ‘user’ entry ‘mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.249882Z 0 [Warning] ‘db’ entry ‘performance_schema mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.250242Z 0 [Warning] ‘db’ entry ‘sys mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.251370Z 0 [Warning] ‘proxies_priv’ entry ‘@ root@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.259019Z 0 [Warning] ‘tables_priv’ entry ‘user mysql.session@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.260028Z 0 [Warning] ‘tables_priv’ entry ‘sys_config mysql.sys@localhost’ ignored in --skip-name-resolve mode.
2019-02-13T09:33:58.295184Z 0 [Note] Event Scheduler: Loaded 0 events
2019-02-13T09:33:58.303140Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.7.23’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
See also printscreen
Does anybody know an answer on how to fix this?
Thanks
Jeroen