[SOLVED] connect to MySQL db from remote system

[darkninja_com]

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,

[fenway]

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.

[darkninja_com]

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,

[fenway]

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...

[darkninja_com]

it's solved, thanks.