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.