去官网下载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'