Remote connection problem

D

Dr-Host

Verified User
Joined
Mar 23, 2004
Messages
109
Location
Israel
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 ?
 
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
 
I don't have a my.cnf file at all; can anyone tell me what the defaults are?

Thanks.

Jeff
 
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
 
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.
 
You must log in or register to reply here.
Back
Top