Archive for March, 2011

MAX_CONNECTIONS_PER_HOUR | mysql.user max_connections, Consternation.

Option (and column) max_connections in the user grants stored in table user is used to represent the maximum of user connections per hour (conforming to the documentation). In order to fulfill the data in this column I use SQL syntax: mysql> GRANT USAGE ON *.* TO ‘test’@’localhost’ WITH MAX_CONNECTIONS_PER_HOUR 5; Query OK, 0 rows affected […]

Read more...