summaryrefslogtreecommitdiff
path: root/files/setmysqlpass.sh
blob: 586775ee6ee78833021def891badf92d2244dfdf (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
#!/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