mysql-5.7.9-winx64 MySQL service failed to start, the service did not report any error resolution

mysql-5.7.9-winx64 MySQL service failed to start, service did not report any errors

The latest decompression version of the MySQL decompression installation error when

D:\mysql-5.7.9-winx64\bin>net start MySQL

The MySQL service is starting.

The MySQL service could not be started.

The service did not report any errors.

MySQL below is no data folder, this folder does not need to build.

D:\mysql-5.7.9-winx64\bin>mysqld--console

2015-11-23T14:46:03.711082Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-11-23T14:46:03.711082Z 0 [Warning] Insecure configuration for--secure-file-priv:current value does not restrict Loc Ation of generated files. Consider setting it to a valid, Non-empty path.

2015-11-23t14:46:03.711583z 0 [Note] mysqld (mysqld 5.7.9) starting as Process 9984 ...

2015-11-23t14:46:03.716585z 0 [Note] innodb:mutexes and rw_locks use Windows interlocked functions

2015-11-23t14:46:03.717086z 0 [Note] innodb:uses event mutexes

2015-11-23t14:46:03.717591z 0 [Note] InnoDB: _mm_lfence () and _mm_sfence () is used for memory barrier

2015-11-23t14:46:03.721090z 0 [Note] innodb:compressed tables use zlib 1.2.3

2015-11-23t14:46:03.726596z 0 [Note] innodb:number of pools:1

2015-11-23t14:46:03.727094z 0 [Note] innodb:not using CPU CRC32 instructions

2015-11-23t14:46:03.764098z 0 [Note] innodb:initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2015-11-23t14:46:03.774101z 0 [Note] innodb:completed initialization of buffer pool

2015-11-23t14:46:03.805645z 0 [Note] innodb:highest supported file format is Barracuda.

2015-11-23t14:46:03.832178z 0 [Note] innodb:creating shared tablespace for temporary tables

2015-11-23t14:46:03.832679z 0 [Note] innodb:setting file '. \ibtmp1 ' size to MB. Physically writing the file full; Please wait ...

2015-11-23t14:46:03.924164z 0 [Note] innodb:file '. \ibtmp1 ' size is now.

2015-11-23t14:46:03.926664z 0 [Note] innodb:96 redo rollback segment (s) found. Redo rollback Segment (s) is active.

2015-11-23t14:46:03.927165z 0 [Note] innodb:32 Non-redo rollback segment (s) is active.

2015-11-23t14:46:03.929749z 0 [Note] innodb:waiting for purge to start

2015-11-23t14:46:03.988759z 0 [Note] innodb:5.7.9 started; Log sequence Number 1209980

2015-11-23t14:46:03.990259z 0 [Note] Innodb:not started

2015-11-23t14:46:03.990759z 0 [Note] innodb:loading buffer pool (s) from D:\mysql-5.7.9-winx64\data\ib_buffer_pool

2015-11-23t14:46:03.990759z 0 [Note] Plugin ' federated ' is disabled.

2015-11-23t14:46:03.996731z 0 [Note] innodb:buffer pool (s) load completed at 151123 22:46:03

Mysqld:table ' mysql.plugin ' doesn ' t exist

2015-11-23t14:46:04.003002z 0 [ERROR] Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it.

2015-11-23t14:46:04.007005z 0 [Warning] Gtid table is not a ready-to-be used. Table ' mysql.gtid_executed ' cannot be opened.

2015-11-23T14:46:04.009510Z 0 [Warning] Failed to set up SSL because of the following SSL library ERROR:SSL context is no T usable without certificate and private key

2015-11-23T14:46:04.015010Z 0 [Note] Server hostname (bind-address): ' * '; port:3306

2015-11-23t14:46:04.016513z 0 [Note] IPv6 is available.

2015-11-23t14:46:04.018012z 0 [Note]-':: ' resolves to ':: ';

2015-11-23t14:46:04.021520z 0 [Note] Server socket created on IP: ':: '.

2015-11-23t14:46:04.029022z 0 [Warning] Failed to open optimizer cost constant tables

2015-11-23t14:46:04.035027z 0 [ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.user ' doesn ' t exist

2015-11-23t14:46:04.037027z 0 [ERROR] aborting

2015-11-23t14:46:04.038528z 0 [Note] Binlog End

2015-11-23t14:46:04.042030z 0 [Note] shutting down plugin ' Ngram '

2015-11-23t14:46:04.045533z 0 [Note] shutting down plugin ' partition '

2015-11-23t14:46:04.048050z 0 [Note] shutting down plugin ' blackhole '

2015-11-23t14:46:04.050550z 0 [Note] shutting down plugin ' ARCHIVE '

2015-11-23t14:46:04.053037z 0 [Note] shutting down plugin ' Performance_schema '

2015-11-23t14:46:04.053539z 0 [Note] shutting down plugin ' Mrg_myisam '

2015-11-23t14:46:04.058545z 0 [Note] shutting down plugin ' MyISAM '

2015-11-23t14:46:04.059544z 0 [Note] shutting down plugin ' innodb_sys_virtual '

2015-11-23t14:46:04.063045z 0 [Note] shutting down plugin ' innodb_sys_datafiles '

2015-11-23t14:46:04.065547z 0 [Note] shutting down plugin ' innodb_sys_tablespaces '

2015-11-23t14:46:04.069049z 0 [Note] shutting down plugin ' Innodb_sys_foreign_cols '

2015-11-23t14:46:04.073053z 0 [Note] shutting down plugin ' innodb_sys_foreign '

2015-11-23t14:46:04.081560z 0 [Note] shutting down plugin ' Innodb_sys_fields '

2015-11-23t14:46:04.084060z 0 [Note] shutting down plugin ' innodb_sys_columns '

2015-11-23t14:46:04.086063z 0 [Note] shutting down plugin ' innodb_sys_indexes '

2015-11-23t14:46:04.088564z 0 [Note] shutting down plugin ' innodb_sys_tablestats '

2015-11-23t14:46:04.100570z 0 [Note] shutting down plugin ' innodb_sys_tables '

2015-11-23t14:46:04.101071z 0 [Note] shutting down plugin ' innodb_ft_index_table '

2015-11-23t14:46:04.103575z 0 [Note] shutting down plugin ' Innodb_ft_index_cache '

2015-11-23t14:46:04.106077z 0 [Note] shutting down plugin ' innodb_ft_config '

2015-11-23t14:46:04.109580z 0 [Note] shutting down plugin ' innodb_ft_being_deleted '

2015-11-23t14:46:04.118084z 0 [Note] shutting down plugin ' innodb_ft_deleted '

2015-11-23t14:46:04.120589z 0 [Note] shutting down plugin ' Innodb_ft_default_stopword '

2015-11-23t14:46:04.123088z 0 [Note] shutting down plugin ' innodb_metrics '

2015-11-23t14:46:04.127091z 0 [Note] shutting down plugin ' Innodb_temp_table_info '

2015-11-23t14:46:04.130093z 0 [Note] shutting down plugin ' innodb_buffer_pool_stats '

2015-11-23t14:46:04.132093z 0 [Note] shutting down plugin ' INNODB_BUFFER_PAGE_LRU '

2015-11-23t14:46:04.135097z 0 [Note] shutting down plugin ' innodb_buffer_page '

2015-11-23t14:46:04.137097z 0 [Note] shutting down plugin ' Innodb_cmp_per_index_reset '

2015-11-23t14:46:04.141601z 0 [Note] shutting down plugin ' Innodb_cmp_per_index '

2015-11-23t14:46:04.144602z 0 [Note] shutting down plugin ' Innodb_cmpmem_reset '

2015-11-23t14:46:04.148106z 0 [Note] shutting down plugin ' Innodb_cmpmem '

2015-11-23t14:46:04.151608z 0 [Note] shutting down plugin ' Innodb_cmp_reset '

2015-11-23t14:46:04.154108z 0 [Note] shutting down plugin ' innodb_cmp '

2015-11-23t14:46:04.158112z 0 [Note] shutting down plugin ' innodb_lock_waits '

2015-11-23t14:46:04.166119z 0 [Note] shutting down plugin ' innodb_locks '

2015-11-23t14:46:04.169622z 0 [Note] shutting down plugin ' Innodb_trx '

2015-11-23t14:46:04.171624z 0 [Note] shutting down plugin ' InnoDB '

2015-11-23t14:46:04.177629z 0 [Note] innodb:fts optimize thread exiting.

2015-11-23t14:46:04.182131z 0 [Note] innodb:starting shutdown ...

2015-11-23t14:46:04.293551z 0 [Note] innodb:dumping buffer pool (s) to D:\mysql-5.7.9-winx64\data\ib_buffer_pool

2015-11-23t14:46:04.295552z 0 [Note] innodb:buffer pool (s) dump completed at 151123 22:46:04

2015-11-23t14:46:05.445554z 0 [Note] Innodb:shutdown completed; Log sequence Number 1209999

2015-11-23t14:46:05.447053z 0 [Note] innodb:removed temporary tablespace data file: "IBTMP1"

2015-11-23t14:46:05.448554z 0 [Note] shutting down plugin ' MEMORY '

2015-11-23t14:46:05.449054z 0 [Note] shutting down plugin ' CSV '

2015-11-23t14:46:05.452556z 0 [Note] shutting down plugin ' Sha256_password '

2015-11-23t14:46:05.458060z 0 [Note] shutting down plugin ' Mysql_native_password '

2015-11-23t14:46:05.459061z 0 [Note] shutting down plugin ' Binlog '

2015-11-23t14:46:05.463065z 0 [Note] mysqld:shutdown complete

D:\mysql-5.7.9-winx64\bin>mysqld--initialize

2015-11-23t14:49:00.783987z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-11-23t14:49:00.785988z 0 [ERROR]--initialize specified but the data directory have files in it. Aborting.

2015-11-23t14:49:00.786989z 0 [ERROR] aborting

The above error is to build the data folder after you use Mysqld--initialize error.

Delete the previously built Data folder, created by MySQL itself.

D:\mysql-5.7.9-winx64\bin>mysqld--initialize

D:\mysql-5.7.9-winx64\bin>net start MySQL

The MySQL service is starting.

The MySQL service has started successfully.

mysql-5.7.9-winx64 MySQL service failed to start, the service did not report any error resolution