Re: [Phplib-users] SQL: more than 'max_user_connections'

[Giancarlo <gia...@na...>]

You have to lower the mysql wait_timeout value from the default 8 h to 
1-5 minutes mas, so stale persistent connections will be freed
This is a FAQ.

Gian

Lindsay Haisley wrote:
> Thus spake so...@gm... on Wed, Feb 19, 2003 at 10:27:31AM CST
> 
>>hello,
>>
>>I keep getting the following mistake from my site:
>>
>>
>>Warning: User net@localhost has already more than 'max_user_connections'
>>active connections in /home/www/net/phplib_lablue/db_mysql.inc on line 73
>>
>>Warning: MySQL Connection Failed: User net@localhost has already more
>>than 'max_user_connections' active connections in
>>/home/www/net/phplib_lablue/db_mysql.inc on line 73
>>Database error: pconnect(localhost, net, $Password) failed.
>>MySQL Error: ()
>>Session halted.
> 
> 
> This is a mysql issue.  You can change max_user_connections in your my.cnf
> file.  Do a locate for it on your system.  This is often set to 0 (no limit)
> but may be set to a specific value which is too low for your situation.  You
> can see the current setting by logging in to mysql with the mysql client and
> giving the 'show variables;' command.
> 
> To set max_user_connections, edit my.cnf and under the [mysqld] section, put
> the following line.
> 
> set-variable    = max_user_connections=0  
>                                         
> Restart the mysql server and the problem should go away.
> 
> This assumes that you administer your own server.  If not, you'll need to   
> get the server admins to take care of the issue.
>