summaryrefslogtreecommitdiff
path: root/templates/setmysqlpass.sh.erb
diff options
context:
space:
mode:
Diffstat (limited to 'templates/setmysqlpass.sh.erb')
-rw-r--r--templates/setmysqlpass.sh.erb2
1 files changed, 2 insertions, 0 deletions
diff --git a/templates/setmysqlpass.sh.erb b/templates/setmysqlpass.sh.erb
index 1cc34db..b3b14b3 100644
--- a/templates/setmysqlpass.sh.erb
+++ b/templates/setmysqlpass.sh.erb
@@ -10,5 +10,7 @@ DEFAULTS="/etc/mysql/debian.cnf"
# Run
/usr/bin/mysql --defaults-file=$DEFAULTS <<EOF
UPDATE mysql.user SET Password=PASSWORD('$PASSWORD') WHERE User='root' AND Host='localhost';
+UPDATE mysql.user SET Password=PASSWORD('$PASSWORD') WHERE User='root' AND Host='<%= fqdn %>';
+UPDATE mysql.user SET Password=PASSWORD('$PASSWORD') WHERE User='root' AND Host='127.0.0.1';
FLUSH PRIVILEGES;
EOF