Stefan Hinz wrote:

It would be nice to extend the user permissions table to have per-user limits like max_user_connections and the various timeouts applying directly to specific user/host combinations.

As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my mysql.user table:

- max_question: number of commands user can send to server,
- max_updates: number of changes user can submit,
- max_connections: well, I let you guess ;-)

Maybe I'll have to take the plunge and upgrade after all.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to