darkninja_com Posted April 18, 2006 Share Posted April 18, 2006 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, Quote Link to comment https://forums.phpfreaks.com/topic/7702-solved-connect-to-mysql-db-from-remote-system/ Share on other sites More sharing options...
fenway Posted April 18, 2006 Share Posted April 18, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/7702-solved-connect-to-mysql-db-from-remote-system/#findComment-28246 Share on other sites More sharing options...
darkninja_com Posted April 19, 2006 Author Share Posted April 19, 2006 Oh... those should be the right solutionsbut 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, Quote Link to comment https://forums.phpfreaks.com/topic/7702-solved-connect-to-mysql-db-from-remote-system/#findComment-28441 Share on other sites More sharing options...
fenway Posted April 19, 2006 Share Posted April 19, 2006 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... Quote Link to comment https://forums.phpfreaks.com/topic/7702-solved-connect-to-mysql-db-from-remote-system/#findComment-28493 Share on other sites More sharing options...
darkninja_com Posted January 31, 2007 Author Share Posted January 31, 2007 it's solved, thanks. Quote Link to comment https://forums.phpfreaks.com/topic/7702-solved-connect-to-mysql-db-from-remote-system/#findComment-173402 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.