Bug #109183 My "max_questions" count value does not reset after an hour.
Submitted: 23 Nov 2022 14:32 Modified: 24 Nov 2022 11:43
Reporter: Francisco Osuna Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:8.0.30 OS:Windows
Assigned to: CPU Architecture:Any

[23 Nov 2022 14:32] Francisco Osuna

Yesterday I changed the value of the option "max_questions" to 20 using the Workbench. Since then, I haven't been able to log in to the Workbench even though more than an hour has passed between attempts.

I receive a pop-up window with the following message:
"Your connection attempt has failed for user 'root' to the MySQL server at localhost:3306:
User 'root' has exceeded the "max_questions" resource (current value:20)

How to repeat:
Changing the "max_questions" default value (0) and trying to log in after an hour (or more).
[23 Nov 2022 14:34] Francisco Osuna
MySQL Server maybe fits better as a category for this bug.
[24 Nov 2022 11:43] MySQL Verification Team
Hello Francisco Osuna,

Thank you for the bug report.
Imho this is duplicate of Bug #84803, please see Bug #84803.

Ashwini Patil