检测mysql密码是否输入正确的脚本

最新推荐文章于 2024-06-13 17:37:22 发布

csdnxw

最新推荐文章于 2024-06-13 17:37:22 发布

阅读量1.9k

点赞数

分类专栏： Linux 发行版/嵌入式文章标签： mysql access user socket function input

本文链接：https://blog.csdn.net/csdnxw/article/details/1884534

版权

Linux 发行版/嵌入式专栏收录该内容

40 篇文章

订阅专栏

MysqlUser='root'
MysqlPassword=''

function CheckMysqlPassword()
{
    if [ -z $MysqlPassword ]
    then
        cmdResult=`mysql -u$MysqlUser -e quit 2>&1`
    else
        cmdResult=`mysql -u$MysqlUser -p$MysqlPassword -e quit 2>&1`
    fi

cmdResultLineCount=`echo $cmdResult | wc -c`

    if(( cmdResultLineCount > 1 ))
    then
        printf "Error occurred! /n" #$cmdResult!/n"
    else
        printf "Connect mysql successfully! /n"
    fi

#printf "cmdResult = $cmdResult /n"

#! for more details:

#! ERROR 1045 (28000): Access denied for user 'root'@'localhost'
AccessDenied=`echo $cmdResult | grep Access.denied | wc -c`

    #if (( AccessDenied > 1 ))
    #then
    #    printf "Connect failed, access denied./n"
    #fi;

#! Can't connect to local MySQL server through socket ...
#CannotConnect=`echo $cmdResult | grep Can.t.connect | wc -c`

    #if (( CannotConnect > 1 ))
    #then
    #    printf "Connect faild, mysql may be not started./n"
    #fi

}

printf "Please input the password for mysql root user:"
read MysqlPassword

CheckMysqlPassword