MySQL External Access
Posted: 04. November 2010 09:25
Hello,
In the past I have used several WAMP programs, but have always had problems with them, mainly in regards to MySQL. So far XAMPP is working rather well, though I have come across a problem and I'm not exactly sure what to do. I am a video game developer who is working on getting up my own own MMORPG. For this I have my games server and a completely separate server that is located outside of my network to host my games website. I need to be able to pass files back and forth from my games website and the mysql databased used to store my games information, but so far all i keep getting is errors.
Website Error:
Game Server Error:
I've been looking for a while now and I can't find ANYTHING that is close to relevant to explain what to do. My router is currently configured to run DMZ, directing all port forwarding to my server. All the ports that are required for XAMPP are open, I have checked this using multiple port checking websites online. I have also edited the my.ini, making sure that bind-address and skip-networking are commented out. I also made sure every port is open within my firewall as well. I've been here for two days trying to figure this out and cant figure it out so I figured it was time to ask for some help.
I am currently using the xampp-win32-1.7.3 installer. I'm running Windows Server 2008 on my game server and my webserver is running Linux. I have remote mysql setup in both, user accounts with wildcard access to any host (%) yet its still not working. Does anyone have any ideas? Is there something in XAMPP somewhere thats blocking it completely?
Thank you for your time and help,
~Dwight
In the past I have used several WAMP programs, but have always had problems with them, mainly in regards to MySQL. So far XAMPP is working rather well, though I have come across a problem and I'm not exactly sure what to do. I am a video game developer who is working on getting up my own own MMORPG. For this I have my games server and a completely separate server that is located outside of my network to host my games website. I need to be able to pass files back and forth from my games website and the mysql databased used to store my games information, but so far all i keep getting is errors.
Website Error:
- Code: Select all
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'server1.shiningashes.net' (4) in /home/divinesh/public_html/serverstatus.php on line 105
Game Server Error:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'divineshadowsonline.com' (10060) in C:\xampp\htdocs\index.php on line 18
Can't connect to MySQL server on 'divineshadowsonline.com' (10060)
I've been looking for a while now and I can't find ANYTHING that is close to relevant to explain what to do. My router is currently configured to run DMZ, directing all port forwarding to my server. All the ports that are required for XAMPP are open, I have checked this using multiple port checking websites online. I have also edited the my.ini, making sure that bind-address and skip-networking are commented out. I also made sure every port is open within my firewall as well. I've been here for two days trying to figure this out and cant figure it out so I figured it was time to ask for some help.
I am currently using the xampp-win32-1.7.3 installer. I'm running Windows Server 2008 on my game server and my webserver is running Linux. I have remote mysql setup in both, user accounts with wildcard access to any host (%) yet its still not working. Does anyone have any ideas? Is there something in XAMPP somewhere thats blocking it completely?
Thank you for your time and help,
~Dwight