MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]

by

Probably the problem is that you have only a handful connections allowed and when your class tries to get a new connection you have this error.

This is not a programming problem, just quantity of resources available. And any other script that uses this class are subject to have the error.

You have to configure more connections on mysql config file on the server. If you don’t have this access, ask the support to do it or change for a hosting company with more connections allowed!

Other option is to implement a Singleton pattern on this class, so it reuses same pool of connections, and don’t explode the limit.

More Related Contents:

  1. How do I ensure I caught all errors from MySQLi::multi_query?
  2. Can I mix MySQL APIs in PHP?
  3. Should we ever check for mysqli_connect() errors manually?
  4. How to change mysql to mysqli?
  5. How to prevent duplicate usernames when people register?
  6. Best way to INSERT many values in mysqli?
  7. SELECT COUNT(*) AS count – How to use this count
  8. How to use mysqli prepared statements?
  9. MySQLi prepared statements error reporting [duplicate]
  10. mysqli last insert id
  11. mysqli: can it prepare multiple queries in one statement?
  12. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  13. How to call a MySQL stored procedure from within PHP code?
  14. MySQLi count(*) always returns 1
  15. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  16. Do I have to guard against SQL injection if I used a dropdown?
  17. Using Mysqli bind_param with date and time columns?
  18. Using MySQLi from another class in PHP
  19. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. Can I blindly replace all mysql_ functions with mysqli_?
  22. Fatal error: Call to undefined function mysqli_result()
  23. Using PHP to execute multiple MYSQL Queries
  24. How to run multiple insert query in SQL using PHP in one go?
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. mysqli persistent connection
  27. Create mysql trigger via PHP?
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. How to make mysqli connect function?

Leave a Comment