einfo "Setting correct privelegies"

	einfo "Setting correct privileges for bugzilla mysql connection"

	mysql -p mysql --exec="GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON ${mybugsdb}.* TO ${mybugsuser}@${mybugshost} IDENTIFIED BY '${mybugspwd}'; FLUSH PRIVILEGES;"  || die

	echo -n "Please enter login info for user who has grant privileges on ${mybugshost} [$USER]: "; read adminuser

	if (test -z $adminuser) ; then adminuser="$USER" ; fi

	if [ "$mybugshost" != "localhost" ]; then

		echo -n "Client address for bugzilla (at db side) [$(hostname -f)]: "; read clientaddr

		if (test -z $clientaddr) ; then clientaddr="$(hostname -f)" ; fi

	fi

	# this will be default for localhost

	if (test -z $clientaddr) ; then clientaddr="${bybugshost}" ; fi

	# if $bugshost == localhost, don't specify -h argument, so local socket can be used.

	host=${mybugshost/localhost}

	mysql -u ${adminuser} ${host:+-h ${host}} -p mysql --exec="GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON ${mybugsdb}.* TO ${mybugsuser}@${clientaddr} IDENTIFIED BY '${mybugspwd}'; FLUSH PRIVILEGES;"  || {

		eerror "Error running query!"

		eerror ""

		eerror "Please run it manually on ${host}."

		eerror ""

		eerror "   \$ mysql -u ${adminuser} -p mysql --exec=\"GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON ${mybugsdb}.* TO ${mybugsuser}@${clientaddr} IDENTIFIED BY '${mybugspwd}'; FLUSH PRIVILEGES;\""

		eerror ""

	}