summaryrefslogtreecommitdiff
path: root/wordpress/worduser-reset-password
blob: d46b3c19deea5dc650e0cedbf5f265e338ecdc39 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
#!/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