summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--templates/setmysqlpass.sh.erb28
1 files changed, 2 insertions, 26 deletions
diff --git a/templates/setmysqlpass.sh.erb b/templates/setmysqlpass.sh.erb
index 902336a..9cb3d39 100644
--- a/templates/setmysqlpass.sh.erb
+++ b/templates/setmysqlpass.sh.erb
@@ -1,36 +1,12 @@
#!/bin/bash
#
-# Set MySQL password.
+# Change MySQL root password.
#
# Config
-SERVICE="/etc/init.d/mysql"
PASSWORD="<%= mysql_rootpw %>"
-DATADIR="/var/lib/mysql/data"
-LOGBIN="/var/lib/mysql/mysql-bin"
-USER="mysql"
-GROUP="mysql"
DEFAULTS="/etc/mysql/debian.cnf"
-# Stop service
-#$SERVICE stop
-
-# Start without grant tables
-# This seems unsafe as opens a race condition.
-#/usr/libexec/mysqld --skip-grant-tables --user=root --datadir=$DATADIR log-bin=$LOGBIN &
-
-# Wait
-#sleep 5
-
-# Change root password
+# Run
echo "USE mysql; UPDATE user SET Password=PASSWORD('$PASSWORD') WHERE User='root' AND Host='localhost';" | \
/usr/bin/mysql --defaults-file=$DEFAULTS
-
-# Kill the daemon
-#killall mysqld
-
-# Chown to be on the safe side
-#chown $USER.$GROUP $LOGBIN*
-
-# Start service
-#$SERVICE start