MySQL - Limiting User Resources?

I want to limit MySQL user resources. On a dual 1 GHz, 4 GB RAM web server I have so far set the following:

set-variable=max_connections=100
set-variable=max_connect_errors=512
set-variable=wait_timeout=30
set-variable=thread_cache_size=80

I want to set a further limit on a *per user basis* if possible e.g. number of queries/updates per hour. What are my options?

BTW what's the difference between max_user_connections and max_connections? And more importantly, how will limiting the max_user_connections affect my users?

Thank you.

 

 

 

 

Top