Jump to content


Photo

[SOLVED] connect to MySQL db from remote system


  • Please log in to reply
4 replies to this topic

#1 darkninja_com

darkninja_com
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 18 April 2006 - 10:11 AM

Hi,

I want to access a MySQL db stored in a diffrent host (not localhost). The error i got was "host XYZ is not allowed to connect to this MySQL server".

Do you know what configuration should be done at the MySQL server to allow connection from remote hosts, and how?

Thank you,

#2 fenway

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

Posted 18 April 2006 - 05:23 PM

Well, you'll need to set up appropriate GRANT permissions specify whatever host/ip you're connecting from; you'll also need to make sure that the server itself is set up to allow non-localhost connections.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 darkninja_com

darkninja_com
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 19 April 2006 - 02:21 AM

Oh... those should be the right solutions

but Im such a newbie to MySQL that don't even know how to do them...

I have full access to the database server, how would I allow non-localhost connections?

Thanks,

#4 fenway

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

Posted 19 April 2006 - 07:48 AM

From what I recall, you need to make sure that "skip-networking" or "bind-address=<localhost>" don't show up in your my.cnf file. I'm sure there are others...
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 darkninja_com

darkninja_com
  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 31 January 2007 - 05:07 AM

it's solved, thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users