我的mysql进不去

Question

我mysql一直error1045，my.ini后面skip_grant_tables也加了，using password也变成NO了，咋还是不行

C:\Users\Administrator>mysqld --initialize --console
2023-06-26T13:05:35.696212Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-06-26T13:05:35.696236Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.31-winx64\bin\mysqld.exe (mysqld 8.0.31) initializing of server in progress as process 14688
2023-06-26T13:05:35.702477Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2023-06-26T13:05:35.702494Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\Program Files\mysql-8.0.31-winx64\data\ is unusable. You can remove all files that the server added to it.
2023-06-26T13:05:35.702953Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-06-26T13:05:35.703112Z 0 [System] [MY-010910] [Server] D:\Program Files\mysql-8.0.31-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.31)  MySQL Community Server - GPL.

C:\Users\Administrator>mysqld --initialize --console
2023-06-26T13:06:21.382980Z 0 [System] [MY-013169] [Server] C:\Program Files\mysql\bin\mysqld.exe (mysqld 8.0.33) initializing of server in progress as process 12816
2023-06-26T13:06:21.417126Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-06-26T13:06:21.711795Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-06-26T13:06:22.639634Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: )4Yk(yWhe.>!

C:\Users\Administrator>mysqld install
The service already exists!
The current server installed: "D:\Program Files\mysql-8.0.31-winx64\bin\mysqld" MySQL

C:\Users\Administrator>net start mysql
请求的服务已经启动。

请键入 NET HELPMSG 2182 以获得更多的帮助。


C:\Users\Administrator>mysql -u root -p
Enter password: ****************（我改的密码）
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

C:\Users\Administrator>mysql -u root -p
Enter password: ************（原密码）
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

C:\Users\Administrator>net stop mysql
MySQL 服务正在停止.
MySQL 服务已成功停止。


C:\Users\Administrator>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

C:\Users\Administrator>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


C:\Users\Administrator>mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Answer 1

这种情况一般是密码错误，如果是刚下载卸载建议重装，安装mysql客户端版本安装比较容易，可以无脑安装，不需要那么多配置