Warning: User xxx@localhost has already more than 'max_user_connections' active connections in /usr/home/xxx/xxx/xxx/public_html/forums/admin/db_mysql.php on line 37


This max_user_connections had being giving me trouble.
I want to set it higher, so it won't give error again.

well are you virtually hosted or have a dedicated server with root access?

if you're virtually hosted you can not change that setting...

if you're on a dedicated server you could change/edit or create a /etc/my.cnf file in telnet as a root user

and put or add into the my.cnf file


set-variable = max_user_connections=0

which then does not set a limit

but if you host has something like

set-variable = max_user_connections=45

that means each user is limited to a max 45 mysql connections - it's there to ensure no one shared hosted client users too much of mysql

hope that helps :)

In vB's config.php in the admin dir, look for this
// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 1;

Set $usepconnect to 0 instead of one, that should fix your problems..

Prohacker, Thanks for helping me.