2、使用mysqld --initialize命令前,不要自己创建data目录,否则无法正常生成全部data目录文件,会出现如下错误提示:
D:\mysql\mysql-5.7.14-winx64\bin>mysqld --initialize
2016-08-25T02:26:39.100728Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-08-25T02:26:39.100728Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2016-08-25T02:26:39.110728Z 0 [ERROR] Aborting
遇到这个问题,就直接删掉自己创建的data目录,然后再执行mysqld --initialize命令即可。