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:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[29 Apr 2016 9:18] Thomas Waibel-BGo
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.