Skip to content

Instantly share code, notes, and snippets.

@terghalin
Last active August 29, 2015 14:10
Show Gist options
  • Select an option

  • Save terghalin/a499932d1eb1bfc5c538 to your computer and use it in GitHub Desktop.

Select an option

Save terghalin/a499932d1eb1bfc5c538 to your computer and use it in GitHub Desktop.
#!/bin/bash
# Deploys new Wordpress site
# Argument = -u username -p password -n database name -d domain name -v
usage()
{
cat << EOF
usage: $0 options
Deploys new WordPress site.
EXAMPLE: deploy-wordpress -u <username> -p <user password> -n <database name> -d <domain name>
OPTIONS:
-h show this message
-u username
-p user password
-n database name
-d domain name
-v verbose
EOF
}
db_username=
db_userpassword=
db_name=
domain_name=
VERBOSE=
while getopts “hu:p:n:d:v” OPTION
do
case $OPTION in
h)
usage
exit 1
;;
u)
db_username=$OPTARG
;;
p)
db_userpassword=$OPTARG
;;
n)
db_name=$OPTARG
;;
d)
domain_name=$OPTARG
;;
v)
VERBOSE=1
;;
?)
usage
exit
;;
esac
done
if [[ -z $db_username ]] || [[ -z $db_userpassword ]] || [[ -z $db_name ]] || [[ -z $domain_na$
then
usage
exit 1
fi
echo "[STATUS] Создаем пользователя $db_username"
if mysql -u root -e "CREATE USER $db_username"; then
echo "[OK] Пользователь $db_username создан."
else
echo "[ERROR] Остановка скрипта из-за ошибки!"
exit 1
fi
SQL_pass_query='SET PASSWORD FOR '$db_username' = PASSWORD('$db_userpassword');"
if mysql -u root -e "$SQL_pass_query"; then
echo "[OK] Установлен пароль для пользователя $db_username"
else
echo "[ERROR] Остановка скрипта из-за ошибки!"
exit 1
fi
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment