Mysql server with Xampp to be accessed by another machine?

Asked

Viewed 3,995 times

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.

mysql web-application server networks xampp
  • 1

    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).

  • 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?

  • 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?

  • 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?

1 answer

2


If I understand your question correctly, you want your database made available on other machines. So in a local network just put the IP of the machine where the installed xammp is.

Example 192.168.1.100 <- IP of the machine where the xammp is installed

192.168.1.100/phpmyadmin

I hope that’s what you wanted, anything and just let me know !

  • I was able to connect remotely via local network, but I can only access by the browser of another device, when accessing by ip in my application the connection is not established, but your answer is not less correct in relation to my question. Thank you for the reply.

Browser other questions tagged mysql web-application server networks xampp

You are not signed in. Login or sign up in order to post.