A fun little script that changes wordpress passwords in a docker-compose setup with wordpress and mysql.

change-wordpress-password.sh

#!/bin/bash

dbContainer="db"
userTable="wordpress.users"
username=${1:-"admin"}
password=${2:-"$username"}

passwordHash=$(docker run --rm -it -v $(pwd)/www:/www php:5.4-cli php -r "\
    include '/www/wp-includes/pluggable.php';\
    define('ABSPATH', '/www/');\
    echo wp_hash_password('$password');")

dbId=$(docker-compose ps -q $dbContainer)
docker exec -i $dbId bash -c "mysql -uroot -p\$MYSQL_ROOT_PASSWORD" <<ESQL
    UPDATE $userTable SET user_pass = "$passwordHash" WHERE user_login = "$username";
ESQL