Re: Can't run MySQL Server 5.7
Posted by: Saïdou Niang
Date: October 18, 2017 12:21PM

I get this output from the console:

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console
2017-10-18T18:19:53.446432Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-10-18T18:19:53.446432Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-10-18T18:19:53.446432Z 0 [Note] mysqld.exe (mysqld 5.7.20-log) starting as process 5828 ...
2017-10-18T18:19:53.446432Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-18T18:19:53.462565Z 0 [Note] InnoDB: Uses event mutexes
2017-10-18T18:19:53.463071Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-18T18:19:53.463576Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-18T18:19:53.464069Z 0 [Note] InnoDB: Number of pools: 1
2017-10-18T18:19:53.464577Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-10-18T18:19:53.468080Z 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2017-10-18T18:19:53.468080Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-10-18T18:19:53.499665Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-18T18:19:53.515201Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-10-18T18:19:53.515201Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-10-18T18:19:53.547669Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2017-10-18T18:19:53.567842Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-10-18T18:19:53.568361Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-10-18T18:19:53.568361Z 0 [Note] InnoDB: Waiting for purge to start
2017-10-18T18:19:53.631342Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 1209961
2017-10-18T18:19:53.631342Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-10-18T18:19:53.631342Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
mysqld: 2017-10-18T18:19:53.631342Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171018 20:19:53
Table 'mysql.plugin' doesn't exist
2017-10-18T18:19:53.631342Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-10-18T18:19:53.646806Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-10-18T18:19:53.646806Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-10-18T18:19:53.646806Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-10-18T18:19:53.646806Z 0 [Note] IPv6 is available.
2017-10-18T18:19:53.646806Z 0 [Note] - '::' resolves to '::';
2017-10-18T18:19:53.646806Z 0 [Note] Server socket created on IP: '::'.
2017-10-18T18:19:53.669042Z 0 [Warning] Failed to open optimizer cost constant tables

2017-10-18T18:19:53.669042Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2017-10-18T18:19:53.669042Z 0 [ERROR] Aborting

2017-10-18T18:19:53.669042Z 0 [Note] Binlog end
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'ngram'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'partition'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'MyISAM'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-10-18T18:19:53.669042Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-10-18T18:19:53.684673Z 0 [Note] Shutting down plugin 'InnoDB'
2017-10-18T18:19:53.700297Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-10-18T18:19:53.700297Z 0 [Note] InnoDB: Starting shutdown...
2017-10-18T18:19:53.815699Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2017-10-18T18:19:53.815699Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171018 20:19:53
2017-10-18T18:19:55.085839Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209980
2017-10-18T18:19:55.085839Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-10-18T18:19:55.085839Z 0 [Note] Shutting down plugin 'MEMORY'
2017-10-18T18:19:55.085839Z 0 [Note] Shutting down plugin 'CSV'
2017-10-18T18:19:55.085839Z 0 [Note] Shutting down plugin 'sha256_password'
2017-10-18T18:19:55.085839Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-10-18T18:19:55.101298Z 0 [Note] Shutting down plugin 'binlog'
2017-10-18T18:19:55.101298Z 0 [Note] mysqld.exe: Shutdown complete

Options: ReplyQuote


Subject
Views
Written By
Posted
273
October 18, 2017 08:43AM
176
October 18, 2017 11:27AM
Re: Can't run MySQL Server 5.7
165
October 18, 2017 12:21PM
93
October 18, 2017 02:56PM
76
October 19, 2017 12:53AM
78
October 19, 2017 01:06AM
87
October 18, 2017 12:26PM
88
October 19, 2017 10:00AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.