summarize the cause of the error:
Add the Data directory under the My.init file (DataDir = F:\mysqldata)
The latest decompression version of the MySQL decompression installation error when
D:\mysql\mysql-5.7.10-winx64\bin>net start MySQL
MySQL service is starting ....
The MySQL service could not be started.
The service did not report any errors.
Please type NET helpmsg 3534 for more help.
MySQL below is no data folder, this folder does not need to build
D:\mysql\mysql-5.7.10-winx64\bin>mysqld--console
2015-12-21t07:25:01.465815z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-21t07:25:01.465815z 0 [Warning] ' no_zero_date ', ' no_zero_in_date ' and ' Error_for_division_by_zero ' SQL modes Should is used with strict mode. They willbe merged with strict mode in a future release.
2015-12-21t07:25:01.465815z 0 [Warning] ' no_auto_create_user ' SQL mode is not set.
2015-12-21t07:25:01.465815z 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-12-21t07:25:01.467815z 0 [Note] mysqld (mysqld 5.7.10-log) starting as Process 3708 ...
2015-12-21t07:25:01.491816z 0 [Warning] No argument is provided to--log-bin, and--log-bin-index is not used; So replication if the this MySQL server acts as a master and have his hostname changed!! Please use the '--log-bin=pc201305252052-bin ' to avoid this problem.
2015-12-21t07:25:01.527818z 0 [Note] innodb:mutexes and rw_locks use Windows interlocked functions
2015-12-21t07:25:01.528818z 0 [Note] innodb:uses event mutexes
2015-12-21t07:25:01.531819z 0 [Note] InnoDB: _mm_lfence () and _mm_sfence () is used for memory barrier
2015-12-21t07:25:01.535819z 0 [Note] innodb:compressed tables use zlib 1.2.3
2015-12-21t07:25:01.540819z 0 [Note] innodb:number of pools:1
2015-12-21t07:25:01.544819z 0 [Note] innodb:not using CPU CRC32 instructions
2015-12-21t07:25:01.654826z 0 [Note] innodb:initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2015-12-21t07:25:01.705829z 0 [Note] innodb:completed initialization of buffer pool
2015-12-21t07:25:01.834836z 0 [Note] innodb:highest supported file format is Barracuda.
2015-12-21t07:25:01.991845z 0 [Note] innodb:creating shared tablespace for temporary tables
2015-12-21t07:25:01.994845z 0 [Note] innodb:setting file '. \ibtmp1 ' size to 12MB. Physically writing the file full; Please wait ...
2015-12-21t07:25:02.264861z 0 [Note] innodb:file '. \ibtmp1 ' size is now.
2015-12-21t07:25:02.275861z 0 [Note] innodb:96 redo rollback segment (s) found.
Redo rollback Segment (s) is active.
2015-12-21t07:25:02.276861z 0 [Note] innodb:32 Non-redo rollback segment (s) is active.
2015-12-21T07:25:02.284862Z 0 [Note] innodb:waiting for purge to start
2015-12-21t07:25:02.335865z 0 [Note] innodb:5.7.10 started; Log sequence Number 1209980
2015-12-21t07:25:02.338865z 0 [Note] Plugin ' federated ' is disabled.
2015-12-21t07:25:02.339865z 0 [Note] innodb:loading buffer pool (s) from F:\mysqldata\ib_buffer_pool
2015-12-21t07:25:02.339865z 0 [Note] innodb:not started mysqld:table ' mysql.plugin ' doesn ' t exist
2015-12-21t07:25:02.348865z 0 [Note] innodb:buffer pool (s) load completed at 151221 15:25:02
2015-12-21t07:25:02.351865z 0 [ERROR] Can ' t open the Mysql.plugin table. Please run Mysql_upgrade to create it.
2015-12-21t07:25:02.396868z 0 [Warning] Gtid table is not a ready-to-be used. Table ' mysql.gtid_executed ' cannot be opened.
2015-12-21t07:25:02.401868z 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-12-21t07:25:02.402868z 0 [Note] Server hostname (bind-address): ' * '; port:3306
2015-12-21t07:25:02.415869z 0 [Note] IPv6 is available.
2015-12-21t07:25:02.416869z 0 [Note]-':: ' resolves to ':: ';
2015-12-21t07:25:02.419869z 0 [Note] Server socket created on IP: ':: '.
2015-12-21t07:25:02.430870z 0 [Warning] Failed to open optimizer cost constant tables
2015-12-21t07:25:02.436870z 0 [ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.user ' doesn ' t exist
2015-12-21t07:25:02.440871z 0 [ERROR] aborting
2015-12-21t07:25:02.441871z 0 [Note] Binlog End
2015-12-21t07:25:02.457872z 0 [Note] shutting down plugin ' Ngram '
2015-12-21t07:25:02.457872z 0 [Note] shutting down plugin ' partition '
2015-12-21t07:25:02.460872z 0 [Note] shutting down plugin ' blackhole '
2015-12-21t07:25:02.463872z 0 [Note] shutting down plugin ' ARCHIVE '
2015-12-21t07:25:02.468872z 0 [Note] shutting down plugin ' Performance_schema '
2015-12-21t07:25:02.468872z 0 [Note] shutting down plugin ' Mrg_myisam '
2015-12-21t07:25:02.475873z 0 [Note] shutting down plugin ' MyISAM '
2015-12-21t07:25:02.476873z 0 [Note] shutting down plugin ' innodb_sys_virtual '
2015-12-21t07:25:02.480873z 0 [Note] shutting down plugin ' innodb_sys_datafiles '
2015-12-21t07:25:02.482873z 0 [Note] shutting down plugin ' innodb_sys_tablespaces '
2015-12-21t07:25:02.493874z 0 [Note] shutting down plugin ' Innodb_sys_foreign_cols '
2015-12-21t07:25:02.495874z 0 [Note] shutting down plugin ' innodb_sys_foreign '
2015-12-21t07:25:02.498874z 0 [Note] shutting down plugin ' Innodb_sys_fields '
2015-12-21t07:25:02.503874z 0 [Note] shutting down plugin ' innodb_sys_columns '
2015-12-21t07:25:02.509875z 0 [Note] shutting down plugin ' innodb_sys_indexes '
2015-12-21t07:25:02.513875z 0 [Note] shutting down plugin ' innodb_sys_tablestats '
2015-12-21t07:25:02.518875z 0 [Note] shutting down plugin ' innodb_sys_tables '
2015-12-21t07:25:02.521875z 0 [Note] shutting down plugin ' innodb_ft_index_table '
2015-12-21t07:25:02.524875z 0 [Note] shutting down plugin ' Innodb_ft_index_cache '
2015-12-21t07:25:02.528876z 0 [Note] shutting down plugin ' innodb_ft_config '
2015-12-21t07:25:02.531876z 0 [Note] shutting down plugin ' innodb_ft_being_deleted '
2015-12-21t07:25:02.537876z 0 [Note] shutting down plugin ' innodb_ft_deleted '
2015-12-21t07:25:02.539876z 0 [Note] shutting down plugin ' Innodb_ft_default_stopword '
2015-12-21t07:25:02.542876z 0 [Note] shutting down plugin ' innodb_metrics '
2015-12-21t07:25:02.545877z 0 [Note] shutting down plugin ' Innodb_temp_table_info '
2015-12-21t07:25:02.553877z 0 [Note] shutting down plugin ' innodb_buffer_pool_stats '
2015-12-21t07:25:02.555877z 0 [Note] shutting down plugin ' INNODB_BUFFER_PAGE_LRU '
2015-12-21t07:25:02.558877z 0 [Note] shutting down plugin ' innodb_buffer_page '
2015-12-21t07:25:02.561878z 0 [Note] shutting down plugin ' Innodb_cmp_per_index_reset '
2015-12-21t07:25:02.563878z 0 [Note] shutting down plugin ' Innodb_cmp_per_index '
2015-12-21t07:25:02.566878z 0 [Note] shutting down plugin ' Innodb_cmpmem_reset '
2015-12-21t07:25:02.572878z 0 [Note] shutting down plugin ' Innodb_cmpmem '
2015-12-21t07:25:02.574878z 0 [Note] shutting down plugin ' Innodb_cmp_reset '
2015-12-21t07:25:02.577878z 0 [Note] shutting down plugin ' innodb_cmp '
2015-12-21t07:25:02.580879z 0 [Note] shutting down plugin ' innodb_lock_waits '
2015-12-21t07:25:02.582879z 0 [Note] shutting down plugin ' innodb_locks '
2015-12-21t07:25:02.584879z 0 [Note] shutting down plugin ' Innodb_trx '
2015-12-21t07:25:02.586879z 0 [Note] shutting down plugin ' InnoDB '
2015-12-21t07:25:02.587879z 0 [Note] innodb:fts optimize thread exiting.
2015-12-21t07:25:02.589879z 0 [Note] innodb:starting shutdown ...
2015-12-21t07:25:02.690885z 0 [Note] innodb:dumping buffer pool (s) to F:\mysqldata\ib_buffer_pool
2015-12-21t07:25:02.698885z 0 [Note] innodb:buffer pool (s) dump completed at 151221 15:25:02
2015-12-21t07:25:03.850951z 0 [Note] Innodb:shutdown completed; Log sequence Number 1209999
2015-12-21t07:25:03.853951z 0 [Note] innodb:removed temporary tablespace data file: "IBTMP1"
2015-12-21t07:25:03.863952z 0 [Note] shutting down plugin ' MEMORY '
2015-12-21t07:25:03.866952z 0 [Note] shutting down plugin ' CSV '
2015-12-21t07:25:03.876953z 0 [Note] shutting down plugin ' Sha256_password '
2015-12-21t07:25:03.879953z 0 [Note] shutting down plugin ' Mysql_native_password '
2015-12-21t07:25:03.882953z 0 [Note] shutting down plugin ' Binlog '
2015-12-21t07:25:03.892954z 0 [Note] mysqld:shutdown complete
D:\mysql\mysql-5.7.10-winx64\bin>mysqld--initialize
2015-12-21t07:28:50.310904z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-21t07:28:50.311904z 0 [Warning] ' no_zero_date ', ' no_zero_in_date ' and ' Error_for_division_by_zero ' SQL modes Should is used with strict mode. They willbe merged with strict mode in a future release.
2015-12-21t07:28:50.311904z 0 [Warning] ' no_auto_create_user ' SQL mode is not set.
2015-12-21t07:28:50.318904z 0 [ERROR]--initialize specified but the data directory have files in it. Aborting.
2015-12-21t07:28:50.324905z 0 [ERROR] aborting
The above error is to build the data folder after you use Mysqld--initialize error.
Delete the previously built Data folder, and then note the DataDir under the My.init file, created by MySQL itself.
D:\mysql-5.7.10-winx64\bin>mysqld--initialize
D:\mysql-5.7.10-winx64\bin>net start MySQL
The MySQL service is starting.
The MySQL service has started successfully.
mysql-5.7.10-winx64 MySQL service failed to start, the service did not report any error resolution
