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