Remote access to database

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Remote access to database

Postby JackJack » 23. June 2020 12:26

Hi everyone,
I installed XAMPP on a Windows server and I created a database. Now I'am trying to connect to this database from another server, not in the same network, using a PHP script but the connection always timed out. I tried a lot of solution I found in the web but none of them worked. The server is configured to remote access but I think XAMPP isn't or I configured it in the wrong way. Have you any working guide to recommend?
Thanks to anyone who will help me
JackJack
 
Posts: 3
Joined: 23. June 2020 12:14
XAMPP version: 7.4.7
Operating System: Windows

Re: Remote access to database

Postby Altrea » 23. June 2020 17:35

There is not much to know

- configure your firewall to allow external connections on port 3306
- create a database user for host % (any host)
- use the IP the xampp computer has as host, username and password to connect to the database.

Of cause these two connection members need to be in the same network (can reach each other)
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10428
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Remote access to database

Postby JackJack » 24. June 2020 08:49

Thank you so much, I think the problem is the port. I have another question: the two member must be in the same network or it is only necessary that they can reach each other?
JackJack
 
Posts: 3
Joined: 23. June 2020 12:14
XAMPP version: 7.4.7
Operating System: Windows

Re: Remote access to database

Postby Altrea » 24. June 2020 08:53

What is the definition of a network? Multiple computers connected to each other.

They don't need to be in the same subnet if they can reach each other by routing.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10428
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Remote access to database

Postby JackJack » 24. June 2020 09:01

Sorry I'm italian, I read a guide (in italian) that says the two computer must be connected to the same Internet network, like WiFi. For me a network is what you said but for the author of the guide isn't.
Thank you for your help and your time!
JackJack
 
Posts: 3
Joined: 23. June 2020 12:14
XAMPP version: 7.4.7
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 68 guests