MySQL query limit per hour with database user creation

Hello,

I need set MySQL query limit per hour and max_user_connections with creation MySQL user by ISPCONFIG. Is it possible?

Thank you!!!

 

Thank you! Where I can find part of code which I have to change?

 

Thank you Till. You are very helpful

 

Till can you check if is it right, please?
I´m not sure, if it is right place in source.

I use $usage_limit variable for define mysql limits.
$usage_limit variable is put two lines down bellow is defined.

Code:

           // Create the database user if database is active
			if($data['new']['active'] == 'y') {
				
				if($data['new']['remote_access'] == 'y') {
          $this->process_host_list('GRANT', $data['new']['database_name'], $data['new']['database_user'], $data['new']['database_password'], $data['new']['remote_ips'], $link);
				}
				$usage_limit = 'WITH MAX_QUERIES_PER_HOUR 100000 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 10';
				$db_host = 'localhost';
				mysql_query("GRANT ALL ON `".str_replace(array('_','%'),array('\\_','\\%'),mysql_real_escape_string($data['new']['database_name'],$link))."`.* TO '".mysql_real_escape_string($data['new']['database_user'],$link)."'@'$db_host' IDENTIFIED BY PASSWORD '".mysql_real_escape_string($data['new']['database_password'],$link)."' ".$usage_limit.";",$link);

				
			}