mysql压缩版一键安装脚本

朱雀 2023-07-22 03:54 174阅读 0赞

请将安装脚本置于与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