n14charlie Posted August 4, 2009 Share Posted August 4, 2009 Hey everyone I'm trying to connect to a remote MySQL server and I'm getting: "Can't connect to MySQL server on 'xxx.xx.xxx.xx' (4)" I googled it and found that a variable in the remote server called "skip networking" must be off in order for it to work, are there any other properties that needs to be changed? Any help will be great Charlie Link to comment https://forums.phpfreaks.com/topic/168851-connecting-to-remote-mysql-server/ Share on other sites More sharing options...
tobimichigan Posted August 4, 2009 Share Posted August 4, 2009 If ur ports are well connected ie localhost, user, pass then I think you should call the attention of your host Link to comment https://forums.phpfreaks.com/topic/168851-connecting-to-remote-mysql-server/#findComment-890892 Share on other sites More sharing options...
n14charlie Posted August 4, 2009 Author Share Posted August 4, 2009 I just realized that my host changed servers and the domain hasn't yet updated - is that might be the reason? thank you Link to comment https://forums.phpfreaks.com/topic/168851-connecting-to-remote-mysql-server/#findComment-890894 Share on other sites More sharing options...
tobimichigan Posted August 4, 2009 Share Posted August 4, 2009 Of course... Link to comment https://forums.phpfreaks.com/topic/168851-connecting-to-remote-mysql-server/#findComment-890908 Share on other sites More sharing options...
n14charlie Posted August 5, 2009 Author Share Posted August 5, 2009 Well turns out my domain is fine and my host is able to connect to other IP mysql servers.. so it's must be a problem with the specific server, anyone knows what properties need to be checked with the mysql server to make sure Im able to connect? Link to comment https://forums.phpfreaks.com/topic/168851-connecting-to-remote-mysql-server/#findComment-891010 Share on other sites More sharing options...
JsusSalv Posted August 5, 2009 Share Posted August 5, 2009 Well turns out my domain is fine and my host is able to connect to other IP mysql servers.. so it's must be a problem with the specific server, anyone knows what properties need to be checked with the mysql server to make sure Im able to connect? Sometimes you need to give IP access to the server that is trying to connect remotely to the database. check out this link and also read the comments at the bottom: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html Host I use has a section for my usernames where I can state which IP addresses can access that particular username's access to database server. So check with your host/server if there is an area to enter allowed IP addresses. Try this Google search as well: "mysql allow ip access" http://www.google.com/search?q=mysql+allow+ip+access&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a Hope it helps a bit. Link to comment https://forums.phpfreaks.com/topic/168851-connecting-to-remote-mysql-server/#findComment-891034 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.