• Hello Guys
    I found this Error many times on my website. When I Open Error Log File then Show this Error. Please Help me anyone.
    Error :-
    [23-Sep-2019 13:37:14 UTC] PHP Warning: mysqli_real_connect(): (42000/1226): User ‘Database Name’ has exceeded the ‘max_user_connections’ resource (current value: 30) in /home/**********/public_html/wp-includes/wp-db.php on line 1612

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Sounds like a little like a database problem to me. I’m wondering why there are so many concurrent connections, too.

    Look at that log file for any other problems and why not ask your web host to take a look?

    Thread Starter ravitaak

    (@ravitaak)

    Hello @jnashhawkins
    I also ask form my web host but anyone not tell me right answer.
    No any other error in error log files and i use only one mysql database user.
    Please help me

    You never mentioned your URL so I couldn’t take a look so, let’s go the other way then.

    swap out the theme for a generic theme. Not that I really think it’s a theme issue.

    Add another database user for your WordPress to use exclusively though I can’t think of a reason for much of anything else querying your database.

    Kill off the plugins by renaming the plugin directory by adding a number or something to the directories name. I usually add the numbers 1234 to the name so I can spot the change easily.

    It might be a plugin causing this.

    Normally you’d use Health Check to do this but in this case, I don’t trust the other running processes which would still be running under Health Check.

    If this doesn’t show you something then I’m not sure what else to do but do let us know what you find. Maybe someone else here will have some ideas.

    If you’ve done some custom coding related to your database access then you really should let us know that as we can’t support custom code but might be able to advise you where to go next.

    As I said before, I’m a little amazed there is that many concurrent database accesses running.

    Thread Starter ravitaak

    (@ravitaak)

    @jnashhawkins Bro I changed already my theme and i deleted all mysql database user and created a new user.

    Thread Starter ravitaak

    (@ravitaak)

    @jnashhawkins Bro i know that this problem is on plugins when this error come then CPU USAGE & I/O USAGE & physical memory Are go 100% then i change Plugin folder name Plugin.old Then it resolve automatically but when i try to change plugin name one by one then this error not solve.

    I see two plugins from my side here but they look weird in the one list.

    WP Smush and some kind of menu plugin… not sure what that is doing for you.

    Rename every plugin the same way… add 1234 or something to each individual plugin’s directory name then check.

    Now rename the ‘plugins’ directory back to normal. Check again. If you have problems with all the plugins disabled then let me know ASAP. I’ll be up late so I should get that.

    If you don’t have any problems rename just one of the plugins back and test again.

    Proceed slowly and test carefully one more then the next and then the next. Test, test, test!

    Thread Starter ravitaak

    (@ravitaak)

    @jnashhawkins
    Bro i do this But Problem Not solved Yet.

    Are you saying that with the plugins directory itself renamed the problem goes away but comes back with any plugin enabled?

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘User ‘root’ has exceeded the ‘max_user_connections’ resource’ is closed to new replies.