Re: Max 8 connections for a user?
Jeremy,
The discussion on the page Peter cited refers prominently (twice in the first paragraph) to the
max_user_connections server system variable. If you read the description of this variable (linked twice from the first paragraph on the page cited), you'll note that the default is 8. Therein lies the source of your issue and a likely solution to same. As Peter notes, there's a CREATE USER option that has a similar effect as setting this variable.
The point being that
MySQL limits connections per user to 8 by default; if you want to permit more than that, you must explicitly increase this limit.
cheers
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle
Subject
Written By
Posted
Re: Max 8 connections for a user?
March 24, 2017 03:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.