Won't this handle half of your issues? http://www.mysql.com/doc/S/e/Security.html
If you want to restrict the number of connections for a single user, you can do this by setting the max_user_connections variable in mysqld. nickg -----Original Message----- From: Dave Dyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 4:18 PM To: [EMAIL PROTECTED] Subject: "Too Many Connections" error Mysql in a shared environment is prone to punish all clients with "too many connections" errors if one client is hyperactive. There seems to be no way to deal with this within the standard framework. This could be dealt with by adding "max_connections_per_ip" and "max_connections_per_user" to protect against deliberate or accidental denial of service by slurping all the available connections. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
