如何从批处理文件安装mysql? [英] How to install mysql from batch file?

问题描述

我正在开发使用 MYSQL 数据库的 Java 桌面应用程序，但我有一个问题，我想嵌入 MYSQL 数据库，为此我想要一个脚本来安装 MYSQL，我需要帮助从批处理文件安装 MYSQL(窗户).

I am working on java desktop application in which i use MYSQL database, but i have a problem , i want to embed MYSQL database, for this i want a script to install the MYSQL, i need Help to install MYSQL from batch file (windows).

我正在使用这个脚本

@echo off
echo Installing MySQL Server. Please wait...

msiexec /i "mysql-installer-community-5.6.14.0.msi" /qn

echo Configurating MySQL Server...

"%ProgramFiles%\MySQL\MySQL Server 5.6\bin\mysqlinstanceconfig.exe" 
-i -q ServiceName=MySQL RootPassword=mysql ServerType=DEVELOPER 
DatabaseType=MYISAM Port=3306 Charset=utf8

echo Installation was successfully

我收到错误，系统找不到指定的路径".

i get the error,"The system cannot find the path specified".

任何帮助将不胜感激.

推荐答案

我的批处理文件已完成:

@echo 关闭
cls
回声 ==========================================
echo MySQL 服务器 - 安装 - v.17/03/2014
回声 ======================================================================================================================================================================================================================================================================================================================================================================================================================================================================
回声.
回声.
rem ----------------------------------------------——
回声安装.等待 ...
msiexec/i "mysql-5.5.28-win32.msi"/qn
回声完成.
rem ----------------------------------------------——
回声.
回声.
rem ----------------------------------------------——
回声配置.等待 ...
cd "C:\Program Files\MySQL\MySQL Server 5.5\bin\"
mysqlinstanceconfig.exe -i -q ServiceName=MySQL RootPassword=mypassword ServerType=DEVELOPER DatabaseType=INODB Port=myport Charset=utf8
回声完成.
rem ----------------------------------------------——
回声.
回声.
rem ----------------------------------------------——
echo 创建对用户的访问.等待 ...
cd "C:\Program Files\MySQL\MySQL Server 5.5\bin\"
mysql -uroot -pmypassword --execute="GRANT ALL PRIVILEGES ON . TO 'root'@'%%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;"
mysql -uroot -pmypassword --execute="FLUSH PRIVILEGES;"
回声完成.
rem ----------------------------------------------——
回声.
回声.
echo 安装准备就绪.
回声.
回声.
暂停

My batch file complete:

@echo off
cls
echo ==========================================
echo MySQL Server - Installation - v.17/03/2014
echo ==========================================
echo .
echo .
rem ------------------------------------------------
echo Installing. Wait ...
msiexec /i "mysql-5.5.28-win32.msi" /qn
echo Done.
rem ------------------------------------------------
echo .
echo .
rem ------------------------------------------------
echo Configurating. Waiting ...
cd "C:\Program Files\MySQL\MySQL Server 5.5\bin\"
mysqlinstanceconfig.exe -i -q ServiceName=MySQL RootPassword=mypassword ServerType=DEVELOPER DatabaseType=INODB Port=myport Charset=utf8
echo Done.
rem ------------------------------------------------
echo .
echo .
rem ------------------------------------------------
echo Creating access to user. Waiting ...
cd "C:\Program Files\MySQL\MySQL Server 5.5\bin\"
mysql -uroot -pmypassword --execute="GRANT ALL PRIVILEGES ON . TO 'root'@'%%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;"
mysql -uroot -pmypassword --execute="FLUSH PRIVILEGES;"
echo Done.
rem ------------------------------------------------
echo .
echo .
echo Installation ready.
echo .
echo .
pause

这篇关于如何从批处理文件安装mysql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！