Limit DirectAdmin MySQL usage for users

#!/bin/sh

#Limits (setting these options to 0 removes the limit)
MAX_QUERIES_PER_HOUR=0
MAX_UPDATES_PER_HOUR=0
MAX_CONNECTIONS_PER_HOUR=0
MAX_USER_CONNECTIONS=0

#We get DirectAdmin MySQL root user and password here
DA_MYSQL=/usr/local/directadmin/conf/mysql.conf
MYSQLUSER=`grep „^user=“ ${DA_MYSQL} | cut -d= -f2`
MYSQLPASSWORD=`grep „^passwd=“ ${DA_MYSQL} | cut -d= -f2`

mysql -e „use mysql; UPDATE mysql.user SET
max_questions=${MAX_QUERIES_PER_HOUR},
max_updates=${MAX_UPDATES_PER_HOUR},
max_connections=${MAX_CONNECTIONS_PER_HOUR},
max_user_connections=${MAX_USER_CONNECTIONS} WHERE user!=’da_admin’ AND
user!=’root’ AND user!=’da_roundcube’ AND user!=’da_atmail’; FLUSH
PRIVILEGES;“ –user=${MYSQLUSER} –password=${MYSQLPASSWORD}

echo „Limits have been set.“
exit 0;