Skip to content

Instantly share code, notes, and snippets.

@mlist
Last active August 29, 2015 14:16
Show Gist options
  • Save mlist/56d115f0678efce055d4 to your computer and use it in GitHub Desktop.
Save mlist/56d115f0678efce055d4 to your computer and use it in GitHub Desktop.
bash script to create a database + user in mysql.
#!/bin/bash
EXPECTED_ARGS=3
E_BADARGS=65
MYSQL=`which mysql`
Q1="CREATE DATABASE IF NOT EXISTS $1;"
Q2="GRANT USAGE ON *.* TO $2@localhost IDENTIFIED BY '$3';"
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 dbpass"
exit $E_BADARGS
fi
$MYSQL -uroot -pstrangehat -e "$SQL"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment