Problems connecting to a mysql database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
InnerShadow
Forum Commoner
Posts: 37
Joined: Thu Nov 10, 2005 10:44 pm
Location: US

Problems connecting to a mysql database

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

The configured allotment of connections may differ between the machines. That is not a hardcoded value, but rather a configuration setting.
InnerShadow
Forum Commoner
Posts: 37
Joined: Thu Nov 10, 2005 10:44 pm
Location: US

Post by InnerShadow »

So i should be very specific on port number and the like?
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post 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
Post Reply