Remote connection problem

[Dr-Host]

I've create a database and a new user with host % and full access to the data base.

this is a data base for a forum use
after 34 users in the forum I can't connect any more
mysqladmin flushosts helps, is there a way to remove this non localhost connection limit ?

 

[thuskey]

create file /etc/my.cnf with the minimum following content:


[mysqld]
set-variable = max_connections=250
set-variable = interactive_timeout = 300
set-variable = wait_timeout = 60

 

[Dr-Host]

I've got in my my.cnf

max_connections=300
interactive_timeout=50
wait_timeout=50

 

[nobaloney]

I don't have a my.cnf file at all; can anyone tell me what the defaults are?

Thanks.

Jeff

 

[Dr-Host]

someone posted here a while ago do search

 

[nobaloney]

I found a bunch of threads, but none listing the default entries; only suggested changes.

Before I try to fix what isn't broken, I'd like to know what the defaults are.

Jeff

 

[thuskey]

There is no one correct answer, each install may end up with different settings. To find out what is currently on your server before making a change, run "SHOW GLOBAL VARIABLES" in a mysql query window.

 

[nobaloney]

Thanks, Travis.

Jeff