max_connections_per_hour

Hi,

I have a contact who is using oscommerce, and is having problems with mysql_connect - error message as follows:
Warning: mysql_connect() [function.mysql-connect]: User 'abc' has exceeded the 'max_connections_per_hour' resource (current value: 300) in /data/htdocs/iabc/shop/includes/functions/database.php on line 19
Unable to connect to database server!

From what I can see from the MySQL site, this relates to mysql server administration and specifically granting priveleges on the account. Can you tell me if this is something only the hosting company can control? If not, any help on changing these limits would be much appreciated!

Many thanks,
Daisy
daisydoosAsked:
Who is Participating?
 
Steve BinkConnect With a Mentor Commented:
From the same link:

 To remove an existing limit, set its value to zero. For example, to remove the limit on how many times per hour francis can connect, use this statement:

mysql> GRANT USAGE ON *.* TO 'francis'@'localhost'
    ->     WITH MAX_CONNECTIONS_PER_HOUR 0;


I've never used connection limits in my projects because they weren't necessary.  In the context of a web site hitting a database through a controlled API, a limit like this would cause all sorts of issues.  :/
0
 
Steve BinkCommented:
See here:

http://dev.mysql.com/doc/refman/5.1/en/user-resources.html

This is something an administrator can change through GRANTs.
0
 
daisydoosAuthor Commented:
Hi there,

Many thanks for your response. I found out a bit more yesterday on this. Do you know what the "sensible" level of max conections per hour is? Can we set it at unlimited?

Many thanks,
Daisy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.