1
I am a complete beginner in dealing with Web programming and local and remote servers, my notion on these subjects is quite partial. Well, I have a system that will need access to a Mysql database. But this server with the database must be on another machine, IE, I need to remotely access the local network where mysql is with xampp.
I researched the subject in several places, several even, and by knowing really little about it, I ended up getting more and more confused. My question is how can I create and/or configure a mysql server with xampp so I can access it remotely? would I need another isolated network for both machines? Or free up online access?
From now on, thank you for your attention.
Note: I can access the bank via the local network of the machine itself using xampp, but the intention was to prove the access via Ip so I can access it via another machine.
XAMPP (Apache, Mysql, PHP and Perl, and X is "cross Platform") is a collection of programs. The Mysql that comes with it is the same that comes "loose" if you download from the original page. If you are going to use only DB remotely, it makes no sense to install all XAMPP. Just take Mysql, or better yet, Mariadb, which is compatible, but with a better and more open evolutionary cycle. Actually XAMPP is a practical way to set up a test environment, but for serious things, I think it’s wiser to install Mariadb, Apache and PHP separately (and Perl if you need to).
– Bacco
First thank you for the answer. Well I have also installed oracle mysql with Workbench, with it I was able to access via local network as well. But in my project the database will be an intermediary between the system and a web application. I thought I would need shaman to create a server for these purposes. For this, you would not recommend shaman?
– Yuri Pires
By your question, we can see that you are very confused about what is actually the XAMPP, but let’s try to get to the point. This server where Mysql will be, is there a reason for it to be Windows? You want your system to access Mysql remotely, so the machine that Mysql will be on needs to have a fixed IP within the local network and this leads us to the second question. Your local network has some router?
– Clayderson Ferreira
The tests of the system with the bank and the web application will be for presentation purposes same, in case the project would be my tcc that is why I am using in windows same. Has router yes, is a Tp-link wr941nd, need to free access to port 80 by it?
– Yuri Pires