#!/bin/sh

control MySQL-server nograntnonet
service mysqld restart

read -r passwd

echo 'select 1;' | mysql &>/dev/null
STATUS=$?
i=0
while [ $i -lt 20 ] && [ "$STATUS" != "0" ]; do
	echo "select 1" | mysql &>/dev/null
	STATUS=$?
	let i=i+1
	if [ "$STATUS" -ge "1" ]; then
		sleep 1
	fi
done

if [ "$i" == "20" ]; then
	echo "can't connect to MySQL server"
	exit 1
fi

echo "UPDATE mysql.user SET Password=password('$passwd') WHERE User='root';" | mysql
echo "FLUSH PRIVILEGES;" | mysql

control MySQL-server grantnonet
/sbin/service mysqld restart
