初始化数据库目录
mysqld --initialize --user=mysql --console
mysql\mysql-5.7.13-winx64\bin>mysqld --initialize --user=mysql --console
2017-01-16T14:59:06.283684Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-16T14:59:06.283684Z 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-01-16T14:59:06.283684Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-01-16T14:59:06.965045Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-01-16T14:59:07.129900Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-01-16T14:59:07.238839Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 54352566-dbfc-11e6-baa7-00155d016902.
2017-01-16T14:59:07.267716Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-01-16T14:59:07.275715Z 1 [Note] A temporary password is generated for root@localhost: ak*09TS/of:4
ak*09TS/of:4:初始化密码
初始化mysql服务
mysqld --install MySQL
启动mysql服务
net start mysql
登录mysql
mysql -uroot -p
重置密码
set password for root@localhost = password('taofangt168');
完成