When building sites I often need to set-up a MySQL database which has all proper settings so I can start working right away knowing that all is fine. Here is a little script which I use to do this;

#!/bin/sh

if [ ! -n “$1” ]; then
echo “Invoke as ./createdb.sh DATABASE_NAME”
exit -1
fi

DBNAME=”$1″

mysqladmin –user=root –password=SOMEPASS create $DBNAME

PASS=`perl -e ‘for($i=0;$i<6;$i++){print rand()*26%26};'`
mysql –user=root –password=SOMEPASS -e “grant all privileges on $DBNAME.* to $DBNAME@’localhost’ identified by ‘$PASS’;”
mysql –user=root –password=SOMEPASS -e “flush privileges;”

echo $PASS