MySQL – Create a database and user with a random password


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" [/bash] [/raw]

Published on: 28 June 2013
Posted by: Sami K.