asked on

MySQL socket vs port

I am trying to write an asp.net page that pulls data from a remote database and am unable to establish a connection. I'm not at the location but when I was I printed off their server information. I noticed that it didn't show a setting for Port:3306. Instead it said Socket: /var/mysql/mysql.sock. Does this mean that I can not access it remotely? If so, can I change a setting to do so? Or can I create a new user on their server that can connect remotely?

ASKER CERTIFIED SOLUTION

Steve Bink

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

profya

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JT_SIRO

ASKER

Thanks for the answers guys. So does the TCP/IP vs. socket setting apply to the entire server? Or can I set that individually for each user? It doesn't appear that way, in the server settings, but I don't know.

My bit concern is this - There are existing web apps that currently hit this db server via the socket (which implies that they are local, right?). I don't want to flip a setting from socket to TCP/IP and bring down their existing apps. That would be very bad. But I do need to establish connectivity remotely. Thanks -

Justin

Steve Bink

Again, they are not mutually exclusive. MySQL can allow connection from both.

profya

I have a similar environment, they are working together, no problems since socket settings are intact.

JT_SIRO

ASKER

thanks -