mysql skip-grant-tables

原创

于 2025-12-06 09:39:55 发布 · 275 阅读

9 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

直接使用：

c:\Program Files\MySQL\MySQL Server 8.2\bin>mysqld --console --skip-grant-tables
2025-12-06T00:02:39.764979Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-12-06T00:02:39.960272Z 0 [System] [MY-010116] [Server] c:\Program Files\MySQL\MySQL Server 8.2\bin\mysqld.exe (mysqld 8.2.0) starting as process 36616
2025-12-06T00:02:39.994202Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory. --找不到数据目录
2025-12-06T00:02:39.995262Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-12-06T00:02:39.995517Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-12-06T00:02:39.996517Z 0 [System] [MY-010910] [Server] c:\Program Files\MySQL\MySQL Server 8.2\bin\mysqld.exe: Shutdown complete (mysqld 8.2.0) MySQL Community Server - GPL.
2025-12-06T00:02:39.997301Z 0 [System] [MY-015016] [Server] MySQL Server - end.

指定配置文件并加上其它参数，成功启动：

c:\Program Files\MySQL\MySQL Server 8.2\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.2\my.ini" --console --skip-grant-tables --shared-memory
2025-12-06T00:08:05.823474Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-12-06T00:08:06.051475Z 0 [System] [MY-010116] [Server] c:\Program Files\MySQL\MySQL Server 8.2\bin\mysqld.exe (mysqld 8.2.0) starting as pr