Page 1 of 1

Problems connecting to a mysql database

Posted: Thu May 04, 2006 11:10 am
by InnerShadow
I have a program that makes several connections of a mysql database over a network to a server running linux. Currently the linux server is refusing the connection and i was wondering if there is anything special about mysql on linux that is different from a windows machine.

Posted: Thu May 04, 2006 11:18 am
by feyd
The configured allotment of connections may differ between the machines. That is not a hardcoded value, but rather a configuration setting.

Posted: Thu May 04, 2006 11:24 am
by InnerShadow
So i should be very specific on port number and the like?

Posted: Fri May 05, 2006 2:05 am
by dibyendrah
I think that can be configured in /etc/mysql/my.cnf .

Code: Select all

set-variable = max_connections=100
<- For simulatenous 200 connections to the mysql db server.

To see the effect, restart the mysql db server.

This applies to if you have db server and want to connect from may clients at same time. But you are trying to connect from one pc to many linux machines, which is confusing !!! Will you please make clear what is the error you are getting ? That will help many people get clear what to write on the topic ..


:roll:

Dibyendra