Limit MySQL queries per user

To be able to set default limits on user's databases, like max queries, updates etc. per hour for that user.

Documentation:
http://dev.mysql.com/doc/refman/5.0/en/user-resources.html

That would be a great feature. +1.

you can do this in da_admin, choosing the user and editing privileges, resource limits

AndyII said:

you can do this in da_admin, choosing the user and editing privileges, resource limits

Click to expand...

Really? Where? I don't see any option on max mysql queries per hour.

AndyII said:

you can do this in da_admin, choosing the user and editing privileges, resource limits

Click to expand...

This doesn't exist.

You must login as server admin (da_admin) with password provided at time of install

Edit Privileges

Resource limits

Note: Setting these options to 0 (zero) removes the limit.
MAX QUERIES PER HOUR
MAX UPDATES PER HOUR
MAX CONNECTIONS PER HOUR


phpMyAdmin gets the users' privileges directly from MySQL's privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.

Yes, you can do it in phpmyadmin. I thought you were talking about doing it within Directadmin.