From 9ec0ef766c210ac6ca26a725701a89031a56fbab Mon Sep 17 00:00:00 2001
From: Jerome Charaoui <jcharaoui@cmaisonneuve.qc.ca>
Date: Thu, 10 Dec 2009 14:52:50 -0500
Subject: make backup and optimize cron jobs optional; introduce
 $mysql_backup_cron, $mysql_backup_dir and$mysql_optimize_cron; use a
 module_dir for scripts

---
 files/scripts/Debian/setmysqlpass.sh | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 files/scripts/Debian/setmysqlpass.sh

(limited to 'files/scripts/Debian/setmysqlpass.sh')

diff --git a/files/scripts/Debian/setmysqlpass.sh b/files/scripts/Debian/setmysqlpass.sh
new file mode 100644
index 0000000..5bd63e2
--- /dev/null
+++ b/files/scripts/Debian/setmysqlpass.sh
@@ -0,0 +1,17 @@
+#!/bin/sh
+
+test $# -gt 0 || exit 1
+
+/etc/init.d/mysql stop
+
+/usr/sbin/mysqld --skip-grant-tables --user=root --datadir=/var/lib/mysql --log-bin=/var/lib/mysql/mysql-bin &
+sleep 5
+echo "USE mysql; UPDATE user SET Password=PASSWORD('$1') WHERE User='root' AND Host='localhost';" | mysql -u root
+killall mysqld
+sleep 5
+# chown to be on the safe side
+ls -al /var/lib/mysql/mysql-bin.* &> /dev/null
+[ $? == 0 ] && chown mysql.mysql /var/lib/mysql/mysql-bin.*
+
+/etc/init.d/mysql start
+
-- 
cgit v1.2.3