MariaDB一键安装

目录

目录下工具包

安装脚本

title mariaDB安装
@echo off

echo 安装开始
%~d0
cd %~dp0mariaDB

start /WAIT winrar-x64-570sc.exe /S
start /WAIT vcredist_x86.exe /S
start /WAIT vcredist_x64.exe /S

set rar="C:\Program Files\WinRAR\WinRAR.exe"
set MARIADB_ROOT=d:\mariaDB
set MARIADB_PORT=3307
set MARIADB_SERVER_NAME=mariaDB
set MARIADB_DIR=%MARIADB_ROOT%\mariadb-10.4.12-winx64
echo 创建目录
md %MARIADB_DIR%
md %MARIADB_DIR%\log

%rar% x -o+ -y mariadb-10.4.12-winx64.zip  *.*  %MARIADB_ROOT%

cd /d %MARIADB_DIR%

echo [mysqld]>>my.ini
echo basedir=%cd:\=\\%\\>>my.ini
echo datadir=%cd:\=\\%\\\data>>my.ini
echo port=%MARIADB_PORT%>>my.ini
echo sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION">>my.ini
echo default_storage_engine=innodb>>my.ini
echo max_connections=100 >>my.ini
echo query_cache_size=0 >>my.ini
echo innodb_strict_mode=0 >>my.ini
echo innodb_file_per_table=1 >>my.ini
echo innodb_buffer_pool_size=2047M>>my.ini
echo innodb_log_file_size=500M>>my.ini
echo max_allowed_packet=500M>>my.ini
echo character-set-server=utf8>>my.ini
echo log-bin=%cd:\=\\%\\log\\mysql-bin>>my.ini
echo log_bin_index=%cd:\=\\%\\log\\mysql-bin.index>>my.ini
echo log_bin_trust_function_creators=1 >>my.ini
echo binlog_format=mixed>>my.ini
echo expire_logs_days=7 >>my.ini
echo max_binlog_size=100m>>my.ini
echo binlog_cache_size=4m>>my.ini
echo max_binlog_cache_size=512m>>my.ini
echo [client]>>my.ini
echo port=%MARIADB_PORT%>>my.ini
echo plugin-dir=%cd:\=\\%\\lib\plugin>>my.ini

cd /d %MARIADB_DIR%\bin
echo 初始化
mysql_install_db
move /Y %MARIADB_DIR%\my.ini %MARIADB_DIR%\data
echo my.ini更新成功

echo 安装服务
mysqld --install mariaDB

echo 启动服务
net start %MARIADB_SERVER_NAME%

if %errorlevel% GEQ 1 (
echo.
echo 数据库启动错误
echo 请检查服务名称，数据库端口及安装目录
echo.
pause
goto :END
)

%~d0
cd %~dp0mariaDB

echo 数据库配置
set MS_CMD=mysql --port=%MARIADB_PORT% --user=root --password=
%MS_CMD% <  .\init.sql
echo 初始化数据库-完成

net stop %MARIADB_SERVER_NAME%
net start %MARIADB_SERVER_NAME%

:END
CLS
echo 安装完成，用户名：root，端口：%MARIADB_PORT%，密码：123456
pause

卸载脚本

title mariaDB卸载
@echo off
net stop mariaDB
sc delete mariaDB
rd /s /q D:\mariaDB

初始化脚本 init.sql

use mysql
ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("123456");
grant all privileges on *.* to root@'%' identified VIA mysql_native_password USING PASSWORD("123456");
set global log_bin_trust_function_creators=1;
flush privileges;

下载链接：https://pan.baidu.com/s/1QCDxXy3Yl_mZXqnNt_I3cg
提取码：4ing