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

[Lindsay H. <fmo...@fm...>]

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.

-- 
Lindsay Haisley       | "Everything works    |     PGP public key
FMP Computer Services |       if you let it" |      available at
512-259-1190          |    (The Roadie)      | <http://www.fmp.com/pubkeys>
http://www.fmp.com    |                      |