#!/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