windows脚本bat一键安装mysql5.7绿色版（创建my.ini、初始化、安装服务、重置root密码）

windows脚本bat一键安装mysql5.7绿色版@echo offecho Please run as administrator.set currentDir=%~dp0set basedir=%currentDir%set mysqld=%currentDir%bin\mysqldset mysqladmin=%currentDir%bin\mysqladminset port=9536

ty41232X32

3923人浏览 · 2022-01-25 15:48:37

ty41232X32 · 2022-01-25 15:48:37 发布

脚本文件直接放到mysql根目录下，以管理员身份执行即可。

注意修改data路径、端口号、设置复杂密码，默认my.ini仅供参考。

install.bat

@echo off

echo Please run as administrator.

set currentDir=%~dp0
set currentDir=%currentDir:\=/%
set basedir=%currentDir%
set mysqld="%currentDir%bin\mysqld"
set mysqladmin="%currentDir%bin\mysqladmin"

set port=9536
set rootPwd=TT@384Tz#$2022c
set datadir=%currentDir%data/
set serviceName=mysql57

(
echo [mysql]
echo default-character-set=utf8
echo [mysqld]
echo character-set-server=utf8
echo port=%port%
echo basedir="%basedir%"
echo datadir="%datadir%"
echo max_connections=200
echo show_compatibility_56=1
echo default-storage-engine=INNODB
echo sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
) > "%basedir%\my.ini"

%mysqld% --initialize-insecure --user=mysql --explicit_defaults_for_timestamp --console

%mysqld% --install %serviceName%

net start %serviceName%

echo The initial password is empty, just press Enter.

%mysqladmin% -P %port% -u root -p password %rootPwd%

pause