asked on

Could you point how to configure MySQL to workaround the 'max_connections_per_hour' error?

Hi Experts

Could you point how to configure MySQL to workaround the 'max_connections_per_hour' error?

mysqli::real_connect(): (42000/1226): user 'root' has exceeded the 'max_connections_per_hour' resource (current value: 50)

Open in new window

Thanks in advance!

SOLUTION

Patrick Bogers

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Eduardo Fuerte

ASKER

Hi

Unfortunatelly I get this error going this way:

Eduardo Fuerte

ASKER

This command runs

GRANT USAGE ON  database_name.*
TO 'root'@'localhost'
WITH MAX_QUERIES_PER_HOUR 1000
MAX_CONNECTIONS_PER_HOUR 100;

Open in new window

Is it sufficient to my purpose?
What do you think abaout?

Eduardo Fuerte

ASKER

The link where I obtained the command:
GRANT - Time and Number of Connection Limits

ASKER CERTIFIED SOLUTION

lenamtl

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Eduardo Fuerte

ASKER

Hi lenamtl

Thank you for the confirmation.
The MySQL version is 5.6 - so the command I used is Ok.

Eduardo Fuerte

ASKER

Thanks for help!

Patrick Bogers

Djeez youre welcome. I did not get any notification for this thread until points were given. Strange.

Anyway good there are more experts that know mysql.

Cheers