Hi,

I hope someone of you guys can help me. I want to limit MySQL for all users each server. We use the current version MySQL 4.0.12. I didn't find any informations on the net how the secure mysql. Any URL's?

The main problem is that there are many users which think the can code mysql but the make a lot of mistakes like a loop or whatever. There must be a possibility to limit such users, isn't there one? If not how can I find such bad guys after a crash? Maybe in a log file? If yes which one?

Thanks.

Regards,
Claudius

whatare the users coding in, php???

if so, then edit the php.ini file

in there you can set the maximum execution time before the server gives up

for example, if the user makes and infinate loop, u can set it, so that after 'x' amount of seconds, it will end the loop

apart from that i have no idea

hope that helps

Hi,

Thanks for your quick answer. Of course we do have already set this to 30 sec but I guess if there is a wrong query request in mysql it is already to late cause the loop is after that generated in the mysql self, isn't it?

Regards,
Claudius

mysql4 have some user resources limits like number of queries per hour, see http://www.mysql.com/doc/en/User_resources.html, but still no efficient way to stop one user to hog the system.