User x already has more than 'max_user_connections' active connections in
Yesterday, my website is inaccessible. The error prompts:
Warning: mysql_connect() [function.mysql-connect]: User x already has more than 'max_user_connections' active connections in /home/musicast/public_html/libs/adodb/drivers/adodb-mysql.inc.php on line 364
Fatal error: Call to a member function GetAll() on a non-object in /home/musicast/public_html/modules/frontend.php on line 26
The hosting not so helpful support told that the user had too many connection and have to look into the script the cause of this and close that connection.
I'm using ADODb connect function to connect to database, not the persistent one, and my assumption it's automatically close when the queries are finish.
I also try the Close() function but it didn't work.
From some searching it is my understanding that your host will need to kill the current connections that are still sitting there open. Once that is accomplished, add the close() function and run a few tests. Then have your host check to see if any connections were still left open, as if they are the close() did nothing to resolve the issue.