1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
#!/bin/bash EXPECTED_ARGS=2 E_BADARGS=65 MYSQL=`which mysql` PASS=`tr -cd '[:alnum:]' < /dev/urandom | fold -w16 | head -n1` echo $PASS Q1="CREATE DATABASE IF NOT EXISTS $1;" Q2="GRANT USAGE ON *.* TO $2@localhost IDENTIFIED BY '$PASS';" Q3="GRANT ALL PRIVILEGES ON $1.* TO $2@localhost;" Q4="FLUSH PRIVILEGES;" SQL="${Q1}${Q2}${Q3}${Q4}" if [ $# -ne $EXPECTED_ARGS ] then echo "Usage: $0 dbname dbuser" exit $E_BADARGS fi $MYSQL -uroot -p -e "$SQL" |