mysql在cmd窗口中获取不到初始密码

Question

我的mysql在cmd操作窗口中获取不到初始密码该怎么办，有前辈说是没删除干净之前下载的mysql文件，现在删除干净了还是一样，获取不到。 在cmd中显示的代码如下 mysqld: Can't create directory 'E:\java\mysql\mysql鈥?.0.22鈥恮inx64\Data\' (OS errno 42 - Illegal byte sequence) 2021-05-19T15:30:14.728395Z 0 [System] [MY-013169] [Server] E:\java\mysql\mysql-8.0.22-winx64\mysql-8.0.22-winx64\bin\mysqld.exe (mysqld 8.0.22) initializing of server in progress as process 5740 2021-05-19T15:30:14.728563Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'E:\java\mysql\mysql鈥?.0.22鈥 恮inx64\mysql鈥?.0.22鈥恮inx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive. 2021-05-19T15:30:14.731002Z 0 [ERROR] [MY-013236] [Server] The designated data directory E:\java\mysql\mysql鈥?.0.22鈥恮inx64\Data\ is unusable. You can remove all files that the server added to it. 2021-05-19T15:30:14.731430Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-05-19T15:30:14.731770Z 0 [System] [MY-010910] [Server] E:\java\mysql\mysql-8.0.22-winx64\mysql-8.0.22-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.22) MySQL Community Server - GPL.

Answer 1

删除残留数据

　　[root@localhost ~]# rm -rf /var/lib/mysql

重启

　　[root@localhost ~]# systemctl restart mysqld

再获得初始密码

　　[root@localhost ~]# cat /var/log/mysqld.log|grep temporary