diff options
| -rw-r--r-- | templates/setmysqlpass.sh.erb | 2 |
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 |