User 'root' has exceeded the 'max_user_connections' resource

musioc

• September 01, 2014 17:21

Hello Recently I get this error in cpanel and so many features are disabled Error Log [QUOTE][2014-09-01 22:15:13 +0000] warn [cpmysql] Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: User 'root' has exceeded the 'max_user_connections' resource (current value: -1) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136
This problem persists even after mysql restart Other users has no problem, all sites are OK I can not open mysql console Or phpmyadmin version: [QUOTE]mysql Ver 15.1 Distrib 5.5.34-MariaDB, for Linux (x86_64) using readline 5.1

• 

  mageshm

  • September 02, 2014 05:59

  @ musioc, You are having root access ? If, so set below on /etc/my.cnf [mysqld] max_connections=500 and restart the mysql service its overcome your issue. For more details, pls refer the below link [url=http://dev.mysql.com/doc/refman/5.0/en/user-resources.html]MySQL :: MySQL 5.0 Reference Manual :: 6.3.4 Setting Account Resource Limits

  0
• 

  musioc

  • September 02, 2014 06:37

  Hello Yes I have root access I think this is not the right way Because all other users are running without any problem. I should change max_user_connections via mysql console, But I can not run mysql via ssh: [QUOTE]root@server [~]# mysql ERROR 1226 (42000): User 'root' has exceeded the 'max_user_connections' resource (current value: -1)
  

  0
• 

  cPanelMichael

  • September 02, 2014 18:00

  Hello :) Try opening /etc/my.cnf and adding or modifying an existing value for: max_user_connections Then, restart MySQL to ensure the change is enacted. Thank you.

  0
• 

  musioc

  • September 04, 2014 07:54

  Thank you, This not help me I was tried max_user_connections = 99999 in my.cnf but no change made (mysql restarted) Then I tried to change Mysql version (cloudlinux dbgovernor) and this solved my problem

  0
• 

  cPanelMichael

  • September 04, 2014 14:52

  [quote="musioc, post: 1722502">Then I tried to change Mysql version (cloudlinux dbgovernor) and this solved my problem
  I am happy to see the issue is now resolved. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.