Bug #116180 User root has exceeded the 'max connections per hour - current value 10.
Submitted: 20 Sep 2024 12:00 Modified: 21 Sep 2024 10:08
Reporter: Yohay Samson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S7 (Test Cases)
Version:8.0.38 OS:Windows (Microsoft Windows 10 Home)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[20 Sep 2024 12:00] Yohay Samson
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Yohays\AppData\Roaming\MySQL\Workbench\log\wb.log]

User root has exceeded the 'max connections per hour - current value 10.
Still get the message even after 1 hour.
Please help I cannot log in.

How to repeat:
try to link to MYSQL mydb as user "root".
[20 Sep 2024 14:13] MySQL Verification Team
HI Mr. Samson,

This page gives you the exact instructions to follow in order to increase that value:

https://dev.mysql.com/doc/refman/8.0/en/alter-user.html

Search for : MAX_CONNECTIONS_PER_HOUR

Closed.
[21 Sep 2024 10:08] Yohay Samson
Sorry it does not work. When I try to set up the 'max connections per hour' I am getting problem with the max_questions current value 10. 
I did try to reinstall the mysql from scratch and it is still remember the wrong set up on my 'root' user. Kindly please I need a solution to this "catch 22".
All me to ask a question. Why you do not have a tool to set the Max values to 0 and reset it ? 

Thank you in advance and sorry for this. I do like your excellent tool but  I have reached "dead end'.

Regards,