Jump to content


Photo

MySQL Connect To Another Server


  • Please log in to reply
3 replies to this topic

#1 Dane

Dane
  • Members
  • PipPipPip
  • Advanced Member
  • 102 posts
  • LocationGrimsby

Posted 11 June 2006 - 11:20 AM

Hi,

I am wanting to connect to the MySQL database of another server, however, it keeps timing out all the time. I have the correct username and password etc and im using host:port etc.

Could you tell me why this is happening? And what could i do about it please?

Cheers

Dane
Nothing....

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 11 June 2006 - 05:39 PM

[!--quoteo(post=382466:date=Jun 11 2006, 07:20 AM:name=Dane)--][div class=\'quotetop\']QUOTE(Dane @ Jun 11 2006, 07:20 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Hi,

I am wanting to connect to the MySQL database of another server, however, it keeps timing out all the time. I have the correct username and password etc and im using host:port etc.

Could you tell me why this is happening? And what could i do about it please?

Cheers

Dane
[/quote]
Are you sure that you're even allowed to connect remotely to this other database?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 Dane

Dane
  • Members
  • PipPipPip
  • Advanced Member
  • 102 posts
  • LocationGrimsby

Posted 11 June 2006 - 08:11 PM

[!--quoteo(post=382562:date=Jun 11 2006, 12:39 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jun 11 2006, 12:39 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Are you sure that you're even allowed to connect remotely to this other database?
[/quote]


Im not sure what the settings are to allow it. Do you know them so that i could check?

Thanks
Nothing....

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 12 June 2006 - 04:51 PM

[!--quoteo(post=382625:date=Jun 11 2006, 04:11 PM:name=Dane)--][div class=\'quotetop\']QUOTE(Dane @ Jun 11 2006, 04:11 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Im not sure what the settings are to allow it. Do you know them so that i could check?

Thanks
[/quote]
Basically, you need to see if "-skip-networking" is enabled or not, and how named pipes are set up.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users