Limit MySQL queries per user

[Splet]

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

 

[smtalk]

That would be a great feature. +1.

 

[AndyII]

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

 

[Splet]

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

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

 

[GXX]

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

This doesn't exist.

 

[AndyII]

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.

 

[GXX]

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