#!/bin/env bash
#tidb_timon_login.sh
#创建timon用户并配置免密登陆
#0为正常,1为异常
_userlogin_list="timon:timonlogin tidb:tidblogin"
function f_check_userlogin
{
    _user=$1
    _loginname=$2

    _login_tidb=$(mysql --login-path=${_loginname} -NBe "select user()" 2>/dev/null)
    rt_code=$?
    _rt_user=$(echo ${_login_tidb}|awk -F"@" '{print $1}')
    echo "kv:${_user}"
    if [ ${rt_code} -eq 0 -a "${_rt_user}" = "${_user}" ]
    then
        echo "kv:0"
    else
        echo "kv:1"
    fi
}

for _userlogin in ${_userlogin_list}
do
    _user="${_userlogin%:*}"
    _login="${_userlogin#*:}"
    f_check_userlogin ${_user} ${_login}
done