windows下mysql8初始化

去官网下载mysql的压缩包解压。
切换到 mysql/bin目录下，运行 mysqld --initialize进行mysql的初始化。或者
mysqld --initialize --user=mysql --console
等运行完毕后，会在bin的上级目录生成一个data文件夹。
找到该目录下的app.err文件，使用文本编辑工具打开：里面内容如下：

2018-12-06T09:19:29.189445Z 0 [System] [MY-013169] [Server] D:\mysql\bin\mysqld.exe (mysqld 8.0.12) initializing of server in progress as process 72472
2018-12-06T09:19:35.585456Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: tH*Kik6-!Bft
2018-12-06T09:19:40.374665Z 0 [System] [MY-013170] [Server] D:\mysql\bin\mysqld.exe (mysqld 8.0.12) initializing of server has completed
2018-12-06T09:22:51.428200Z 0 [System] [MY-010116] [Server] D:\mysql\bin\mysqld.exe (mysqld 8.0.12) starting as process 71876

找到A temporary password is generated for root@localhost: 后面就是生成的root的临时密码，用该密码登录后，修改root密码。

ALTER USER 'root'@'localhost'