首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >批处理MySQL if else语句

问批处理MySQL if else语句
EN

Stack Overflow用户
提问于 2014-11-17 23:40:54
回答 1查看 426关注 0票数 1

我正在尝试创建一个批处理脚本,它将在执行时创建一个数据库。如果数据库已经存在,脚本应该回显它已经存在。我让它在Linux上运行,但它在Windows上显然有很大不同。

下面是脚本:

代码语言:javascript
复制
@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
)

输出结果如下所示:

代码语言:javascript
复制
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语句似乎不能正常工作...

致以亲切的问候,丹尼斯

EN

回答 1

Stack Overflow用户

发布于 2014-11-18 01:27:06

请在if语句'echo %RESULT% and %dbname%‘之前执行,它将帮助您了解发生此问题的原因

我建议将if更改为if "% result %“== "%dbname%”结果变量包含命令的字符串,但未执行..因此,您必须执行它,并将输出放入其中。请检查以下内容:

代码语言:javascript
复制
@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之前,我做了一个类似的批次

我希望这能有所帮助!

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/26976293

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档