User XY already has more than 'max_user_connections' active connections

postcd

• July 08, 2014 07:59

Got this from my php script: [QUOTE]User myusernamehere already has more than 'max_user_connections' active connections
please what/where i need to change in WHM?

• 

  dalem

  • July 09, 2014 02:01

  edit /etc/my.cnf add max_user_connections = or set per user via MySQL cli UPDATE mysql.user SET max_user_connections = xx WHERE user='db_user' AND host='localhost'; FLUSH PRIVILEGES;

  0
• 

  postcd

  • July 10, 2014 23:00

  thx, when i have this in my.cnf: [QUOTE]max_connections=150 max_user_connections=15
  does it mean i dont need to care about second value, does not relate to the issue?

  0
• 

  iserversupport

  • July 10, 2014 23:07

  You may have to optimize the MySQL query to use less connection or increase the value max_user_connections

  0

Please sign in to leave a comment.