blob: 6e700f657f899adcb691e73f5ea727d8fb6c1ed6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
#!/bin/bash
#
# Change MySQL root password.
#
# Config
PASSWORD="<%= @rootpw %>"
DEFAULTS="/etc/mysql/debian.cnf"
# Run
/usr/bin/mysql --defaults-file=$DEFAULTS <<EOF
UPDATE mysql.user SET <%= @password_string %>('$PASSWORD') WHERE User='root' AND Host='localhost';
UPDATE mysql.user SET <%= @password_string %>('$PASSWORD') WHERE User='root' AND Host='<%= @fqdn %>';
UPDATE mysql.user SET <%= @password_string %>('$PASSWORD') WHERE User='root' AND Host='127.0.0.1';
UPDATE mysql.user SET <%= @password_string %>('$PASSWORD') WHERE User='root' AND Host='::1';
FLUSH PRIVILEGES;
EOF
|