Jump to content

Archived

This topic is now archived and is closed to further replies.

darkninja_com

[SOLVED] connect to MySQL db from remote system

Recommended Posts

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,

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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,

Share this post


Link to post
Share on other sites
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...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.