test/bin/reset-wordpress-password
Bernhard Rosenkränzer 30bdb3148a Replace calls to mysql/mysqldump with mariadb/mariadb-dump
The compat symlinks have been removed in current mariadb containers.
Let's not run into nasty surprises when we update.
2025-02-18 13:46:37 +01:00

13 lines
502 B
Bash
Executable File

#!/bin/sh
if [ "$#" != 1 ]; then
cat <<EOF
Usage: $0 <new password>
EOF
exit 1
fi
. /federated/apps/pdnsmysql/.env
. /etc/federated
NEWPASS=$(echo -n "$1" |md5sum - |cut -d' ' -f1)
docker exec -ti pdnsmysql /bin/bash -c "echo \"UPDATE wp_users SET user_pass='$NEWPASS' WHERE user_login='admin@$DOMAIN'\" | mariadb -u root -p$MYSQL_ROOT_PASSWORD wordpress"
docker exec -ti pdnsmysql /bin/bash -c "echo \"SELECT user_login,user_pass FROM wp_users;\" | mariadb -u root -p$MYSQL_ROOT_PASSWORD wordpress"