Max User Connections

Question

I have received following error: How can fix this error?

Warning: mysql_connect() [function.mysql-connect]: User av_admin already has more than 'max_user_connections' active connections in/home/av/public_html/qa-include/qa-db.php on line 66

Could not establish database connection. Please check the username, password and hostname in the config file, and if necessary set up the appropriate MySQL user and privileges.

 

 

Answer 1

Do you have persistent connections turned on? That can cause problems. In Q2A it's this option in qa-config.php:

define('QA_PERSISTENT_CONN_DB', false);

But note that even when this is set to false, if you have persistent connections elsewhere in your own PHP code it may break things. If you're on shared hosting there may not be anything you can do about it.

Comments

Thanks for the answer. I have a dedicated server (hostgator). I don't have my own php code, just q2a 1.5.2 installed.