目录
报错大图
第一步:关闭MySQL服务
net stop mysql
或者
net stop mysql80
第二步:跳过安全检查
cd C:\Program Files\MySQL\MySQL Server 8.0\bin(Mysql默认安装地址)
mysqld --console --skip-grant-tables --shared-memory
可能报错及解决方式
报错
2023-04-09T06:46:08.231417Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.26) starting as process 10856
2023-04-09T06:46:08.233896Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2023-04-09T06:46:08.234017Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2023-04-09T06:46:08.234202Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2023-04-09T06:46:08.235858Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-04-09T06:46:08.236010Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.26) MySQL Community Server - GPL.
解决办法
添加my.ini配置文件路径解决:
mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --skip-grant-tables --shared-memory
第三步:新建cmd窗口进入MySQL
mysql -u root -p
不输入密码,直接回车进入
第四步:重置密码为空(一定要为空)
use mysql;
update user set authentication_string='' where user='root';
第五步:设置登录密码
需要关闭所有cmd窗口,启动MySQL服务后,重新打开一个窗口。
启动MySQL服务
net start mysql
或者
net start mysql80
设置登录密码
cd C:\Program Files\MySQL\MySQL Server 8.0\bin(Mysql默认安装地址)
mysql -u root -p
不输入密码,直接回车进入
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
123456为新密码
至此大功告成。
参考链接