Bug #24758 max_user_connections=0 doesn't work had to set a value to make it work

• Submitted: 1 Dec 2006 19:08
• Modified: 5 Dec 2007 19:55
• Reporter: Jim Rendant
• Status: Verified
• Category: Server: Options
• Severity: S3 (Non-critical)
• Version: 5.0.27, 4.1 BK, 5.1 BK
• OS: Linux (Fedora Core6)
• Assigned to: Alexey Kopytov
• Triage: Triaged: D3 (Medium) / R2 (Low) / E3 (Medium)

[1 Dec 2006 19:08] Jim Rendant

Description:
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 20:55] Sveta Smirnova

Thank you for the report.

Verified as described on Linux using last BK sources.