已经下载好MySQL数据库,但是eclipse连接数据库一直失败
操作环境:windows10
软件版本:MySQL server8.0 eclipse JavaEE版
进入命令提示符窗口,在MySQL的bin目录下进行mysqld --consold,弹出来下面的问题
D:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld --console
2022-04-10T09:51:47.391654Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-04-10T09:51:47.394018Z 0 [System] [MY-010116] [Server] D:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.20) starting as process 23088
2022-04-10T09:51:49.753728Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-04-10T09:51:49.758515Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2022-04-10T09:51:49.758872Z 1 [ERROR] [MY-012278] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2022-04-10T09:51:49.760258Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2022-04-10T09:51:49.763775Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-04-10T09:51:49.764854Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-04-10T09:51:49.767542Z 0 [System] [MY-010910] [Server] D:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL.
解决连接不成功的问题。
1、关闭mysqld进程;
2、删除配置文件中data的目录下面的两个文件ib_logfile0,ib_logfile1,重启mysql服务
如果上面无法解决问题就将mysql进程关闭,删除data文件夹,使用管理员打开cmd,重新初始化这个mysql数据库即可