Server maintenance scripts

db

#!/bin/bash

flag=5

if [ ! $1 ]; then
    echo "Set user name for connect to mysql"
    let flag=flag-1
fi

if [ ! $2 ]; then
    echo "Set user password for connect to mysql"
    let flag=flag-1
fi

if [ ! $3 ]; then
    echo "U must set database name at third parameter"
    let flag=flag-1
fi

if [ ! $4 ]; then
    echo "U must set user name at fourth parameter"
    let flag=flag-1
fi

if [ ! $5 ]; then
    echo "U must set user password at fifth parameter"
    let flag=flag-1
fi

if [ $flag = 5 ]; then
    # create database
    mysql -u$1 -p$2 -e "create database $3 character set utf8 collate utf8_unicode_ci;"
    mysql -u$1 -p$2 -e "show databases;"
    mysql -u$1 -p$2 -e "create user $4;"
    mysql -u$1 -p$2 -e "grant all on $3.* to '$4'@'localhost' identified by '$5';"
fi