#!/bin/bash
set -ex

   domain=${1:-freetailtherapy.com}
   dbname=${2:-${domain//./_}}
   prefix=${3:-wp_gbk4p2}
 username=${4:-wordpress_$dbname}
usertable=${5:-${prefix}_users}
     user=${6:-Jodi}

[ "$domain" ]
[ -d /srv/"$domain" ]

if [ -t 0 ]
then
	read -p "Enter new password: " password
else
	password=$(tr -cd a-z0-9 < /dev/urandom | head -c10)
fi

mysql "$dbname" <<END
select id, user_login, user_pass from $usertable;
update $usertable set user_pass=MD5('$password') where user_login='$user';
select id, user_login, user_pass from $usertable;
END