summaryrefslogtreecommitdiff
path: root/files/config/CentOS/setmysqlpass.sh
blob: f4fbe12a3be73ca7069c11dc0a7d5dfc2b13055b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
#!/bin/sh

test $# -gt 0 || exit 1

/sbin/service mysqld stop

/usr/libexec/mysqld --skip-grant-tables --user=root &
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