From 2929379eb88fe6941f28033d84e545f3c3a95e53 Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Sun, 6 Feb 2011 14:02:09 -0200
Subject: Setting also root passwords for fqdn and 127.0.0.1 hosts

---
 templates/setmysqlpass.sh.erb | 2 ++
 1 file changed, 2 insertions(+)

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
-- 
cgit v1.2.3