1. 下载安装组件包:https://zhuanlan.zhihu.com/p/722160133https://learn.microsoft.com/zh-cn/cpp/windows/latest-supported-vc-redist?view=msvc-170https://aka.ms/vs/17/release/vc_redist.x64.exe#Visual C++ 2015-2022 Redistributable (x64) 最新受支持 x64 版本的永久链接。 X64 可再发行程序包包含 ARM64 和 X64 二进制文件。2.下载 (mysql-9.2.0-winx64.zip) 解压到 E:\Program Files\mysql-9.2.0-winx64下载地址:https://dev.mysql.com/downloads/#最新版为 MySQL Community Server 9.2.0 Innovation3.配置环境变量此电脑右键 - 属性 - 高级系统设置 - 环境变量 - 系统变量 - 新建 -MYSQL_HOME 值为 E:\Program Files\mysql-9.2.0-winx64Path 追加 %MYSQL_HOME%\bin;%MYSQL_HOME%我把它写成一个脚本文件 "添加MYSQL路径到Path环境变量.cmd"， 见文末4. 配置 my.ini 文件创建文件 E:\Program Files\mysql-9.2.0-winx64\my.ini内容:[mysql]# utf8mb4default-character-set=utf8mb4[mysqld]# 设置mysql的安装目录basedir=E:\\Program Files\\mysql-9.2.0-winx64# 设置mysql数据库的数据的存放目录datadir=E:\\Program Files\\mysql-9.2.0-winx64\\data# 设置端口(查看是否占用 netstat -ano | findstr 3306)port=3306# 允许最大连接数max_connections=200# 允许连接失败的次数max_connect_errors=10# 服务端使用的字符集默认为 utf8mb4character-set-server=utf8mb4# 创建新表时将使用的默认存储引擎default-storage-engine=INNODB# 创建模式sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES5.安装命令及日志E:\Program Files\mysql-9.2.0-winx64>mysqld -removeThe service doesn''t exist!E:\Program Files\mysql-9.2.0-winx64>rd /q/s dataE:\Program Files\mysql-9.2.0-winx64>mysqld --initialize --user=mysql --console2025-03-18T09:04:21.108215Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.2025-03-18T09:04:21.113562Z 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.2025-03-18T09:04:21.113732Z 0 [System] [MY-013169] [Server] E:\Program Files\mysql-9.2.0-winx64\bin\mysqld.exe (mysqld 9.2.0) initializing of server in progress as process 1562025-03-18T09:04:21.129186Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2025-03-18T09:04:21.509195Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.2025-03-18T09:04:23.193272Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: rvoBF(;o07W-2025-03-18T09:04:24.932435Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.E:\Program Files\mysql-9.2.0-winx64>mysqld --installService successfully installed.E:\Program Files\mysql-9.2.0-winx64>net start mysqlMySQL 服务正在启动 .MySQL 服务已经启动成功。6. 参考教程:
https://dev.mysql.com/doc/refman/8.4/en/windows-install-archive.html
https://www.52pojie.cn/thread-1944678-1-1.html
https://blog.csdn.net/weixin_44698389/article/details/105363480
https://blog.csdn.net/atu1111/article/details/105183536
https://zhuanlan.zhihu.com/p/722160133:: -----------------------------------------------------------------------------------------------------------文件名： "添加MYSQL路径到Path环境变量.cmd"
文件内容:@REM 为系统变量PATH增加路径：@echo off&setlocal EnableDelayedExpansion
:BEGINclsfor %%a in ("%CD%\..") do set "path_=%%~fa"set "path+=%path_%\bin\"REM set/p path_=请输入你要添加的环境变量的路径：set "keyPath=HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Environment"@if not defined path_ goto :ERRORREM Windows XP skip=4for /f "skip=2 tokens=1,2,*" %%a in ('reg query "%keyPath%" /v Path') do (echo 当前的系统环境变量为:echo %%c&echo;set/p yesno=是否确认将"%path_%"添加到系统环境变量中去？[Y^|yes]/[N^|no] : if /i "!yesno!"=="yes" set yesno=yif /i "!yesno!"=="y" (set "$path=%%c"if "!$path:~-1!"==";" set "$path=!$path:~0,-1!">nul reg add "%keyPath%" /v Path /t REG_EXPAND_SZ /d "!$path!;%path+%;%path_%" /f@if !errorlevel!==0 echo.&echo 已成功将文件路径添加到 Path 系统环境变量。重启 Python 窗口生效。&pause&goto :EOF)if /i "!yesno!"=="no" set yesno=n@if /i "!yesno!"=="n" echo.&echo 已取消操作。&pause&goto :EOF@goto :ERROR)@echo "发生未知错误！"&pause&goto :EOF :ERRORecho 输入错误，请重新输入。&pause
@goto :BEGIN:: -----------------------------------------------------------------------------------------------------------:GetUserPrivilege@echo off&rem 在域中登录当前用户时，开启来宾用户，成则管理员，败则普通用户>nul 2>nul net user guest /active:yesset a=%errorlevel%if /i %a% EQU 0 goto :1if /i %a% EQU 5 goto :2:2mshta javascript:window.alert("%a%------------------现用户为普通权限------------------%a%");window.close()@goto :EOF:1>nul 2>nul net user guest /active:nomshta javascript:window.alert("%a%------------------现用户为管理员权限------------------%a%");window.close()
@goto :EOF
1. 下载安装组件包:
https://zhuanlan.zhihu.com/p/722160133
https://learn.microsoft.com/zh-cn/cpp/windows/latest-supported-vc-redist?view=msvc-170
https://aka.ms/vs/17/release/vc_redist.x64.exe#Visual C++ 2015-2022 Redistributable (x64) 最新受支持 x64 版本的永久链接。 X64 可再发行程序包包含 ARM64 和 X64 二进制文件。
2.下载 (mysql-9.2.0-winx64.zip) 解压到
E:\Program Files\mysql-9.2.0-winx64
下载地址:
https://dev.mysql.com/downloads/#最新版为 MySQL Community Server 9.2.0 Innovation
3.配置环境变量
此电脑右键 - 属性 - 高级系统设置 - 环境变量 - 系统变量 - 新建 -
MYSQL_HOME 值为 E:\Program Files\mysql-9.2.0-winx64
Path 追加 %MYSQL_HOME%\bin;%MYSQL_HOME%
我把它写成一个脚本文件 "添加MYSQL路径到Path环境变量.cmd"， 见文末
4. 配置 my.ini 文件
创建文件 E:\Program Files\mysql-9.2.0-winx64\my.ini
内容:
[mysql]
# utf8mb4
default-character-set=utf8mb4
[mysqld]
# 设置mysql的安装目录
basedir=E:\\Program Files\\mysql-9.2.0-winx64
# 设置mysql数据库的数据的存放目录
datadir=E:\\Program Files\\mysql-9.2.0-winx64\\data
# 设置端口(查看是否占用 netstat -ano | findstr 3306)
port=3306
# 允许最大连接数
max_connections=200
# 允许连接失败的次数
max_connect_errors=10
# 服务端使用的字符集默认为 utf8mb4
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 创建模式
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
5.安装命令及日志
E:\Program Files\mysql-9.2.0-winx64>mysqld -remove
The service doesn''t exist!
E:\Program Files\mysql-9.2.0-winx64>rd /q/s data
E:\Program Files\mysql-9.2.0-winx64>mysqld --initialize --user=mysql --console
2025-03-18T09:04:21.108215Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2025-03-18T09:04:21.113562Z 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.
2025-03-18T09:04:21.113732Z 0 [System] [MY-013169] [Server] E:\Program Files\mysql-9.2.0-winx64\bin\mysqld.exe (mysqld 9.2.0) initializing of server in progress as process 156
2025-03-18T09:04:21.129186Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-03-18T09:04:21.509195Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-03-18T09:04:23.193272Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: rvoBF(;o07W-
2025-03-18T09:04:24.932435Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
E:\Program Files\mysql-9.2.0-winx64>mysqld --install
Service successfully installed.
E:\Program Files\mysql-9.2.0-winx64>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
6. 参考教程:
https://dev.mysql.com/doc/refman/8.4/en/windows-install-archive.html
https://www.52pojie.cn/thread-1944678-1-1.html
https://blog.csdn.net/weixin_44698389/article/details/105363480
https://blog.csdn.net/atu1111/article/details/105183536
https://zhuanlan.zhihu.com/p/722160133
:: -----------------------------------------------------------------------------------------------------------
文件名： "添加MYSQL路径到Path环境变量.cmd"
文件内容:
@REM 为系统变量PATH增加路径：
@echo off&setlocal EnableDelayedExpansion
:BEGIN
cls
for %%a in ("%CD%\..") do set "path_=%%~fa"
set "path+=%path_%\bin\"
REM set/p path_=请输入你要添加的环境变量的路径：
set "keyPath=HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Environment"
@if not defined path_ goto :ERROR
REM Windows XP skip=4
for /f "skip=2 tokens=1,2,*" %%a in ('reg query "%keyPath%" /v Path') do (
echo 当前的系统环境变量为:
echo %%c&echo;
set/p yesno=是否确认将"%path_%"添加到系统环境变量中去？[Y^|yes]/[N^|no] :
if /i "!yesno!"=="yes" set yesno=y
if /i "!yesno!"=="y" (
set "$path=%%c"
if "!$path:~-1!"==";" set "$path=!$path:~0,-1!"
>nul reg add "%keyPath%" /v Path /t REG_EXPAND_SZ /d "!$path!;%path+%;%path_%" /f
@if !errorlevel!==0 echo.&echo 已成功将文件路径添加到 Path 系统环境变量。重启 Python 窗口生效。&pause&goto :EOF
)
if /i "!yesno!"=="no" set yesno=n
@if /i "!yesno!"=="n" echo.&echo 已取消操作。&pause&goto :EOF
@goto :ERROR
)
@echo "发生未知错误！"&pause&goto :EOF
:ERROR
echo 输入错误，请重新输入。&pause
@goto :BEGIN
:: -----------------------------------------------------------------------------------------------------------
:GetUserPrivilege
@echo off&rem 在域中登录当前用户时，开启来宾用户，成则管理员，败则普通用户
>nul 2>nul net user guest /active:yes
set a=%errorlevel%
if /i %a% EQU 0 goto :1
if /i %a% EQU 5 goto :2
:2
mshta javascript:window.alert("%a%------------------现用户为普通权限------------------%a%");window.close()
@goto :EOF
:1
>nul 2>nul net user guest /active:no
mshta javascript:window.alert("%a%------------------现用户为管理员权限------------------%a%");window.close()
@goto :EOF
)