summaryrefslogtreecommitdiff
path: root/files/scripts/CentOS/setmysqlpass.sh
diff options
context:
space:
mode:
Diffstat (limited to 'files/scripts/CentOS/setmysqlpass.sh')
-rw-r--r--files/scripts/CentOS/setmysqlpass.sh15
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
+