diff options
author | root <root@vps-18a7a2b7.vps.ovh.ca> | 2023-05-23 20:40:57 -0400 |
---|---|---|
committer | root <root@vps-18a7a2b7.vps.ovh.ca> | 2023-05-23 20:40:57 -0400 |
commit | 14594b48bb00935e9db6a4dc1352ef8bc1a49061 (patch) | |
tree | 064759af32abdefae5bc5895e911544d810087e3 /wordpress/wordpress-reset-user-password | |
parent | 6de131fad90634cc4c42d4827bdc800fb2d44192 (diff) |
renames
Diffstat (limited to 'wordpress/wordpress-reset-user-password')
-rwxr-xr-x | wordpress/wordpress-reset-user-password | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/wordpress/wordpress-reset-user-password b/wordpress/wordpress-reset-user-password new file mode 100755 index 0000000..d46b3c1 --- /dev/null +++ b/wordpress/wordpress-reset-user-password | |||
@@ -0,0 +1,26 @@ | |||
1 | #!/bin/bash | ||
2 | set -ex | ||
3 | |||
4 | domain=${1:-freetailtherapy.com} | ||
5 | dbname=${2:-${domain//./_}} | ||
6 | prefix=${3:-wp_gbk4p2} | ||
7 | username=${4:-wordpress_$dbname} | ||
8 | usertable=${5:-${prefix}_users} | ||
9 | user=${6:-Jodi} | ||
10 | |||
11 | [ "$domain" ] | ||
12 | [ -d /srv/"$domain" ] | ||
13 | |||
14 | if [ -t 0 ] | ||
15 | then | ||
16 | read -p "Enter new password: " password | ||
17 | else | ||
18 | password=$(tr -cd a-z0-9 < /dev/urandom | head -c10) | ||
19 | fi | ||
20 | |||
21 | mysql "$dbname" <<END | ||
22 | select id, user_login, user_pass from $usertable; | ||
23 | update $usertable set user_pass=MD5('$password') where user_login='$user'; | ||
24 | select id, user_login, user_pass from $usertable; | ||
25 | END | ||
26 | |||