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

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

# Run
echo "USE mysql; UPDATE user SET Password=PASSWORD('$PASSWORD') WHERE User='root' AND Host='localhost';" | \
  /usr/bin/mysql --defaults-file=$DEFAULTS