MySQL Bugs: #81231: Adjust error message #42000 max_user

Bug #81231	Adjust error message #42000 max_user_connections
Submitted:	29 Apr 2016 9:18
Reporter:	Thomas Waibel-BGo	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.7	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Hi,
we connect from more than one host using a single user account to a mysql server and applied max_user_connections to 100 per host per user in mysql.user.

We realised that we have Aborted_connections and tried to analyse the cause using tcpdump.

The error message we get from that dump does not show the source of the problem properly, since the host information is missing.

How to repeat:
Set in mysql.user max_user_connections to 1.

Open 1 connection

Open second connection.

Message appears without originating host.

Suggested fix:
1) Please add to the max_user_connections reached error message the originating host (#42000)

2) The error message should be logged in the error log.