MySQL Forums
Forum List  »  Security

MAX_CONNECTION_PER_HOUR seems have some problem
Posted by: Andrew Chan
Date: February 27, 2009 12:50AM

Thanks in advance for reading

I am doing a Proof of concept for now

MySQL 5.1.31 running on Windows Server 2008, and client using Windows Vista

I've typed the following

GRANT ALL on *.* TO peter@pc01.systematic.com
WITH MAX_UPDATES_PER HOUR 1
MAX_CONNECTIONS_PER_HOUR 2
MAX_USER_CONNECTIONS 4;

I then type SHOW GRANTS for peter@pc01.systematic.com, everything seems normal

then I login windows vista (pc01.systematic.com)
Then I use the GUI tool MySQL Query Browser, login with peter
The UPDATE limit works
The MAX_USER_CONNECTIONS works
but when I close the MySQL Query Browser, and re-launch it (within an hour), peter can login again as many as he wants.

did I misunderstand the meaning of this limit or I have done something wrong

Thank you so much for reading the post

Regards
Andrew Chan.

Options: ReplyQuote


Subject
Views
Written By
Posted
MAX_CONNECTION_PER_HOUR seems have some problem
5884
February 27, 2009 12:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.