diff options
| -rw-r--r-- | templates/setmysqlpass.sh.erb | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/templates/setmysqlpass.sh.erb b/templates/setmysqlpass.sh.erb index 6e700f6..95946b0 100644 --- a/templates/setmysqlpass.sh.erb +++ b/templates/setmysqlpass.sh.erb @@ -9,9 +9,9 @@ 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'; +UPDATE mysql.user SET <%= @authentication_string %>('$PASSWORD') WHERE User='root' AND Host='localhost'; +UPDATE mysql.user SET <%= @authentication_string %>('$PASSWORD') WHERE User='root' AND Host='<%= @fqdn %>'; +UPDATE mysql.user SET <%= @authentication_string %>('$PASSWORD') WHERE User='root' AND Host='127.0.0.1'; +UPDATE mysql.user SET <%= @authentication_string %>('$PASSWORD') WHERE User='root' AND Host='::1'; FLUSH PRIVILEGES; EOF |