检测mysql密码是否输入正确的脚本_链接mysql 账号密码检查脚本-优快云博客

本文介绍了一个用于检查MySQL数据库连接的Shell脚本。该脚本根据提供的用户名和密码尝试连接到MySQL，并返回连接是否成功的消息。如果连接失败，还会提供错误信息以帮助诊断问题。

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