Bug #24758 max_user_connections=0 doesn't work had to set a value to make it work
Submitted: 1 Dec 2006 18:08 Modified: 5 Dec 2007 18:55
Reporter: Jim Rendant Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.0.27, 4.1 BK, 5.1 BK OS:Linux (Fedora Core6)
Assigned to: CPU Architecture:Any

[1 Dec 2006 18:08] Jim Rendant
While max_user_connections is set to 0 only one session is available. It affects both local & remote connections.

How to repeat:
In the my.cnf the max_user_connections=0
Try opening 2 sessions withthe same user ID

Suggested fix:
1. Change the max_user_connections=(arbitrary number ie. > 0)
2. Fix the variable
[1 Dec 2006 19:55] Sveta Smirnova
Thank you for the report.

Verified as described on Linux using last BK sources.
[1 Dec 2011 6:28] Johan Bogema
issue hereby seen on the Windows 5.1.58-community edition