mysql初始用户密码

时间:2024-04-16 21:51:09

好久没用过mysql了,今天下了重新安装,发现和以前的版本有很多不同,比如要先执行初始化命令再安装,还要选allow public key retrieval,更重要的是初始密码是 initialize的时候生成的,具体在 data/*.error下 

2020-08-16T15:41:29.971629Z 0 [System] [MY-013169] [Server] D:\mysql\mysql-8.0.21-winx64\bin\mysqld.exe (mysqld 8.0.21) initializing of server in progress as process 36760
2020-08-16T15:41:29.992526Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-08-16T15:41:30.449549Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-08-16T15:41:31.919060Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: >ytHhI#vN83?
2020-08-16T15:50:50.777196Z 0 [System] [MY-010116] [Server] D:\mysql\mysql-8.0.21-winx64\bin\mysqld.exe (mysqld 8.0.21) starting as process 11528
2020-08-16T15:50:50.791002Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

不过这时间对不上啊,日期倒是能对上,难道用的是其他时区?

 

时区已解决serverTimezone=UTC