#!/bin/bash
#
# Set MySQL password.
#

CONF="/root/.my.cnf"

# Check config file
if [ ! -e "$CONF" ]; then
  echo "File not found: $CONF"
  exit 1
fi

# Get password from configuration
passwd="`grep ^'password='` $CONF | cut -d '=' -f 2"

# Set the password
echo "USE mysql; UPDATE user SET Password=PASSWORD('$passwd') WHERE User='root' AND Host='localhost';" | /usr/bin/mysql -u root