#!/bin/sh

ip=$1
port=$2
db=$3
user=$4
passwd=$5

opuser=op_admin
oppwd="uOhB^@%jBr4LRT!h*wIt5#8D3"
newip=10.66.99.204
newport=3306

if [ "$passwd" == "drop" ];then
    if [ "$ip" != "10.104.2.216" ];then
        echo "Drop user '${user}'@'%';" | mysql -h$ip -P$port -u$opuser -p$oppwd
    else
        echo "Drop user '${user}'@'%';" | mysql -h$newip -P$newport -u$opuser -p$oppwd
    fi
else
    if [ "$ip" != "10.104.2.216" ];then
        echo "grant SELECT ON ${db}.* TO '${user}'@'%' IDENTIFIED BY '${passwd}';" | mysql -h$ip -P$port -u$opuser -p$oppwd
    else
        echo "grant SELECT ON ${db}.* TO '${user}'@'%' IDENTIFIED BY '${passwd}';" | mysql -h$newip -P$newport -u$opuser -p$oppwd
    fi
fi