Mysql 安装指南（小白入门)
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
内容:
# utf8mb4
default-character-set=utf8mb4
# 设置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 MySQL Server Initialization - start.
2025-03-18T09:04:21.113562Z 0 '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 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 InnoDB initialization has started.
2025-03-18T09:04:21.509195Z 1 InnoDB initialization has ended.
2025-03-18T09:04:23.193272Z 6 A temporary password is generated for root@localhost: rvoBF(;o07W-
2025-03-18T09:04:24.932435Z 0 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_%"添加到系统环境变量中去？/ :
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
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
内容:
# utf8mb4
default-character-set=utf8mb4
# 设置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 MySQL Server Initialization - start.
2025-03-18T09:04:21.113562Z 0 '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 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 InnoDB initialization has started.
2025-03-18T09:04:21.509195Z 1 InnoDB initialization has ended.
2025-03-18T09:04:23.193272Z 6 A temporary password is generated for root@localhost: rvoBF(;o07W-
2025-03-18T09:04:24.932435Z 0 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_%"添加到体系环境变量中去？/ :
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
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]