#!/bin/bash
#
# Change MySQL root password.
#

# Config
PASSWORD="<%= mysql_rootpw %>"
DEFAULTS="/etc/mysql/debian.cnf"

# Run
/usr/bin/mysql --defaults-file=$DEFAULTS <<EOF
UPDATE mysql.user SET Password=PASSWORD('$PASSWORD') WHERE User='root' AND Host='localhost';
FLUSH PRIVILEGES;
EOF