请将安装脚本置于与bin目录同级的根目录下

5.0版本安装脚本

@echo off

if  %~dp0 == %cd%\ ( 
echo 请使用管理员身份执行脚本,按下回车键终止此次安装！
set /p in=
exit
)

echo mysql5.0压缩版一键安装脚本...
echo 即将开始安装...
set /p password=请设置密码:

if not defined password (
echo 您没有输入密码,按下回车键终止此次安装!
set /p in=
exit
)


rem 将当前路径存储起来
set path=%~dp0
rem 进入当前路径
cd /d %path%
rem 将配置文件名存储起来
set ini=my.ini
rem 创建data文件夹
mkdir data

rem 向my.ini文件输出内容
echo [Client] >> %ini%
echo.
echo port = 3306 >> %ini%
echo.
echo [mysqld] >> %ini%
echo.
echo port = 3306 >> %ini%
echo.
echo basedir=%path% >> %ini%
echo.
echo datadir=%path%\data >> %ini%
echo.
echo max_connections=200 >> %ini%
echo.
echo character-set-server=utf8 >> %ini%
echo.
echo default-storage-engine=InnoDB >> %ini%
echo.
echo sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES >> %ini%
echo.
echo skip-grant-tables >> %ini%
echo.
echo [mysql] >> %ini%
echo.
echo default-character-set=utf8 >> %ini%

rem 进入bin目录
cd /d %path%\bin
rem 执行mysql安装命令
start /b /wait mysqld -install
rem 执行mysql初始化命令
start /b /wait mysqld --initialize --console
rem 启动mysql服务
start /b /wait net start mysql
rem 设置root用户密码
start /b /wait mysql -uroot -pnon -e "update mysql.user set authentication_string=PASSWORD('%password%') where user='root' and host='localhost';"
rem 停止mysql服务
start /b /wait net stop mysql
rem 进入根目录
cd /d %path%
rem 清空my.ini文件
CD. > %ini%
rem 向my.ini文件输出内容
echo [Client] >> %ini%
echo.
echo port = 3306 >> %ini%
echo.
echo [mysqld] >> %ini%
echo.
echo port = 3306 >> %ini%
echo.
echo basedir=%path% >> %ini%
echo.
echo datadir=%path%\data >> %ini%
echo.
echo max_connections=200 >> %ini%
echo.
echo character-set-server=utf8 >> %ini%
echo.
echo default-storage-engine=InnoDB >> %ini%
echo.
echo sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES >> %ini%
echo.
echo [mysql] >> %ini%
echo.
echo default-character-set=utf8 >> %ini%

rem 启动mysql服务
start /b /wait net start mysql

pause>nul

8.0版本

注意：

1、先用管理员执行install.bat
2、然后执行mysqld --console --skip-grant-tables --shared-memory
3、然后新开一个cm窗口，不输入密码登录mysql后，分别执行以下语句
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'ok' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ok';
flush privileges;

4、关闭所有cmd窗口，再执行net start mysql启动服务，便可正常使用了
 

install.bat如下

@echo off

set sysPath=%cd%

if  %~dp0 == %cd%\ ( 
echo 请使用管理员身份执行脚本,按下回车键终止此次安装！
set /p in=
exit
)


echo mysql8.0压缩版一键安装脚本...
echo 即将开始安装...

set /p password=请设置密码:
if not defined password (
echo 您没有输入密码,按下回车键终止此次安装!
set /p in=
exit
)

set /p serviceName=请设置服务名称:
if not defined serviceName (
echo 您没有输入服务名称,按下回车键终止此次安装!
set /p in=
exit
)

set /p port=请设置端口号:
if not defined port (
echo 您没有输入端口号,按下回车键终止此次安装!
set /p in=
exit
)


rem 将当前路径存储起来
set path=%~dp0
rem 进入当前路径
cd /d %path%
rem 将配置文件名存储起来
set ini=my.ini
rem 创建data文件夹
mkdir data

rem 向my.ini文件输出内容
echo [Client] >> %ini%
echo.
echo port = %port% >> %ini%
echo.
echo [mysqld] >> %ini%
echo.
echo port = %port% >> %ini%
echo.
echo basedir=%path% >> %ini%
echo.
echo datadir=%path%\data >> %ini%
echo.
echo max_connections=200 >> %ini%
echo.
echo character-set-server=utf8 >> %ini%
echo.
echo default-storage-engine=InnoDB >> %ini%
echo.
echo sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES >> %ini%
echo.
echo [mysql] >> %ini%
echo.
echo default-character-set=utf8 >> %ini%

rem 进入bin目录
cd /d %path%\bin

rem 执行mysql安装命令
start /b /wait mysqld -install %serviceName% --defaults-file=“%path%\my.ini”

cd /d %sysPath%
start /b /wait reg add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\%serviceName%" /v ImagePath /t REG_EXPAND_SZ /d "%path%\bin\mysqld %serviceName%" /f


cd /d %path%\bin


rem 执行mysql初始化命令
start /b /wait mysqld --defaults-file=%path%\my.ini --initialize --console


pause>nul