一键安装mysql8.0.44（附脚本）

双击一个文件就自动安装完成安装后默认密码为root可以直接使用非常方便。直接上脚本echo off chcp 65001 nul title MySQL 8.0.44 一键安装工具 color 0A :: 以管理员权限运行 nul 21 %SYSTEMROOT%\system32\cacls.exe %SYSTEMROOT%\system32\config\system if %errorlevel% neq 0 ( echo 请求管理员权限... goto UACPrompt ) else ( goto gotAdmin ) :UACPrompt echo Set UAC CreateObject^(Shell.Application^) %temp%\getadmin.vbs echo UAC.ShellExecute %~s0, , , runas, 1 %temp%\getadmin.vbs %temp%\getadmin.vbs exit /B :gotAdmin if exist %temp%\getadmin.vbs ( del %temp%\getadmin.vbs ) echo echo MySQL 8.0.44 一键安装工具 echo echo. :: 检查是否已安装MySQL sc query MySQL80 nul 21 if %errorlevel% EQU 0 ( echo [错误] MySQL80服务已存在 echo 请先卸载现有MySQL服务 pause exit ) :: 设置变量 set MYSQL_VERSION8.0.44 set MYSQL_ZIPmysql-8.0.44-winx64.zip set INSTALL_DIRC:\mysql-8.0.44 set DATA_DIR%INSTALL_DIR%\data set CONFIG_FILE%INSTALL_DIR%\my.ini set TEMP_DIR%TEMP%\mysql_install :: 清理临时目录 if exist %TEMP_DIR% ( rmdir /s /q %TEMP_DIR% ) mkdir %TEMP_DIR% :: 检查ZIP文件是否存在 if not exist %MYSQL_ZIP% ( echo [错误] 未找到 %MYSQL_ZIP% echo 请将此批处理文件放在MySQL ZIP文件同级目录 pause exit ) echo [1/8] 正在解压MySQL文件... :: 使用系统自带的tar解压Win10 1709支持 tar -xf %MYSQL_ZIP% -C %TEMP_DIR% 2nul if errorlevel 1 ( echo [错误] 解压失败请确保系统支持tar命令 echo 或者使用WinRAR/7-Zip手动解压 pause exit ) echo [2/8] 正在复制文件到安装目录... if exist %INSTALL_DIR% ( echo 删除旧安装目录... rmdir /s /q %INSTALL_DIR% 2nul ) xcopy %TEMP_DIR%\mysql-8.0.44-winx64\* %INSTALL_DIR%\ /E /I /Y /Q echo [3/8] 正在创建数据和日志目录... if not exist %DATA_DIR% mkdir %DATA_DIR% if not exist %INSTALL_DIR%\logs mkdir %INSTALL_DIR%\logs if not exist %INSTALL_DIR%\tmp mkdir %INSTALL_DIR%\tmp echo [4/8] 正在创建配置文件... ( echo [mysqld] echo port3306 echo basedir%INSTALL_DIR:\\\% echo datadir%DATA_DIR:\\\% echo character-set-serverutf8mb4 echo default-storage-engineINNODB echo sql-modeSTRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION echo max_connections200 echo max_connect_errors10 echo table_open_cache2000 echo tmp_table_size64M echo max_heap_table_size64M echo thread_cache_size10 echo myisam_max_sort_file_size100G echo myisam_sort_buffer_size68M echo key_buffer_size16M echo read_buffer_size64K echo read_rnd_buffer_size256K echo sort_buffer_size256K echo innodb_flush_log_at_trx_commit1 echo innodb_log_buffer_size8M echo innodb_buffer_pool_size128M echo innodb_log_file_size48M echo innodb_thread_concurrency8 echo log-error%INSTALL_DIR:\\\%\\logs\\error.log echo slow_query_log1 echo slow_query_log_file%INSTALL_DIR:\\\%\\logs\\slow_query.log echo long_query_time2 echo log-bin%INSTALL_DIR:\\\%\\logs\\mysql-bin echo binlog_formatROW echo server-id1 echo. echo [mysql] echo default-character-setutf8mb4 echo. echo [client] echo port3306 echo default-character-setutf8mb4 ) %CONFIG_FILE% echo [5/8] 初始化MySQL数据库... cd /d %INSTALL_DIR%\bin mysqld --initialize-insecure --console if errorlevel 1 ( echo [错误] 初始化失败 pause exit ) echo [6/8] 安装MySQL服务... mysqld --install MySQL80 if errorlevel 1 ( echo [错误] 服务安装失败 pause exit ) echo [7/8] 启动MySQL服务... net start MySQL80 if errorlevel 1 ( echo [错误] 服务启动失败 goto cleanup ) echo [8/8] 设置root密码... mysql -u root --skip-password -e ALTER USER rootlocalhost IDENTIFIED BY root; FLUSH PRIVILEGES; echo. echo echo MySQL 8.0.44 安装完成 echo echo 安装目录: %INSTALL_DIR% echo 数据目录: %DATA_DIR% echo 配置文件: %CONFIG_FILE% echo. echo 连接信息: echo 用户名: root echo 密码: root echo 端口: 3306 echo. echo 请及时修改root密码 echo 修改命令: mysqladmin -u root -p password 新密码 echo echo. :cleanup :: 清理临时文件 if exist %TEMP_DIR% ( rmdir /s /q %TEMP_DIR% ) :: 添加到系统PATH setx PATH %INSTALL_DIR%\bin;%PATH% /m nul echo MySQL已添加到系统PATH重启终端后生效 echo. pause exit :error_exit echo 安装过程中出现错误 pause exit /b 1工具下载地址http://www.zrscsoft.com/sitepic/12175.html