diff options
author | Jerome Charaoui <jcharaoui@cmaisonneuve.qc.ca> | 2009-12-10 14:52:50 -0500 |
---|---|---|
committer | Jerome Charaoui <jcharaoui@cmaisonneuve.qc.ca> | 2009-12-10 14:52:50 -0500 |
commit | 9ec0ef766c210ac6ca26a725701a89031a56fbab (patch) | |
tree | b4164616ac1558a790f33ff6e3bdbe89915da7c0 /files/scripts/CentOS/setmysqlpass.sh | |
parent | 4a24fffe14abc4ac89322c2707ec6b16d46c0917 (diff) |
make backup and optimize cron jobs optional; introduce $mysql_backup_cron, $mysql_backup_dir and$mysql_optimize_cron; use a module_dir for scripts
Diffstat (limited to 'files/scripts/CentOS/setmysqlpass.sh')
-rw-r--r-- | files/scripts/CentOS/setmysqlpass.sh | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/files/scripts/CentOS/setmysqlpass.sh b/files/scripts/CentOS/setmysqlpass.sh new file mode 100644 index 0000000..d762a20 --- /dev/null +++ b/files/scripts/CentOS/setmysqlpass.sh @@ -0,0 +1,15 @@ +#!/bin/sh + +test $# -gt 0 || exit 1 + +/sbin/service mysqld stop + +/usr/libexec/mysqld --skip-grant-tables --user=root --datadir=/var/lib/mysql/data --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 +# chown to be on the safe side +chown mysql.mysql /var/lib/mysql/mysql-bin.* + +/sbin/service mysqld start + |