我正在尝试创建一个批处理脚本,它将在执行时创建一个数据库。如果数据库已经存在,脚本应该回显它已经存在。我让它在Linux上运行,但它在Windows上显然有很大不同。
下面是脚本:
@echo off
SET dbname=1234
SET user=1234
SET password=1234
SET hostinfo=test3
SET RESULT="mysql -u root -ppassword --skip-column-names -e SHOW DATABASES LIKE '%dbname%'"
if %RESULT% == "%dbname%" (
echo "The database already exists. You can use the reinstall function instead."
) else (
mysql -h localhost -u root -ppassword -e "CREATE USER '%user%'@'%%'"
mysql -h localhost -u root -ppassword -e "SET PASSWORD FOR '%user%'@'%%' = PASSWORD('%password%')"
mysql -h localhost -u root -ppassword -e "GRANT USAGE ON * . * TO '%user%'@'%%' IDENTIFIED BY '%password%' WITH MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0"
mysql -h localhost -u root -ppassword -e "CREATE DATABASE IF NOT EXISTS `%dbname%`"
mysql -h localhost -u root -ppassword -e "GRANT ALL PRIVILEGES ON `%dbname%` . * TO '%user%'@'%%'"
echo A new MySQL database has been created for you.
echo Username: %user%
echo Password: %password%
echo Database: %dbname%
echo Host: %hostinfo%:3306
)输出结果如下所示:
Warning: Using a password on the command line interface can be insecure.
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for '1234'@'%'
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
A new MySQL database has been created for you.
Username: 1234
Password: 1234
Database: 1234
Host: test3:3306我该怎么做呢?if else语句似乎不能正常工作...
致以亲切的问候,丹尼斯
发布于 2014-11-18 01:27:06
请在if语句'echo %RESULT% and %dbname%‘之前执行,它将帮助您了解发生此问题的原因
我建议将if更改为if "% result %“== "%dbname%”结果变量包含命令的字符串,但未执行..因此,您必须执行它,并将输出放入其中。请检查以下内容:
@echo off
SET dbname=1234
SET user=1234
SET password=1234
SET hostinfo=test3
SET RESULT="mysql -u root -ppassword --skip-column-names -e SHOW DATABASES LIKE '%dbname%'"
for /f "delims=" %%i in ('%RESULT%') do set RESULT=%%i
if %RESULT% == "%dbname%" (
echo "The database already exists. You can use the reinstall function instead."
) else (
mysql -h localhost -u root -ppassword -e "CREATE USER '%user%'@'%%'"
mysql -h localhost -u root -ppassword -e "SET PASSWORD FOR '%user%'@'%%' = PASSWORD('%password%')"
mysql -h localhost -u root -ppassword -e "GRANT USAGE ON * . * TO '%user%'@'%%' IDENTIFIED BY '%password%' WITH MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0"
mysql -h localhost -u root -ppassword -e "CREATE DATABASE IF NOT EXISTS `%dbname%`"
mysql -h localhost -u root -ppassword -e "GRANT ALL PRIVILEGES ON `%dbname%` . * TO '%user%'@'%%'"
echo A new MySQL database has been created for you.
echo Username: %user%
echo Password: %password%
echo Database: %dbname%
echo Host: %hostinfo%:3306
)在查看这篇文章http://muhammadhamed.blogspot.com/2013/01/install-mysql-as-windows-service-from.html之前,我做了一个类似的批次
我希望这能有所帮助!
https://stackoverflow.com/questions/26976293
复制相似问题