How to set Xampp's mysql on public IP

[chinmayborkar3]

Hi Team,

Now I am using XAMPP's mysql on localhost but Now for connectivity from outside the on-premise server. I need the document or a way to set it on a public IP. So, that I can access it from another server which is not connected in LAN. Please reply ASAP.



Thanks
Chinmay Borkar

[chinmayborkar3]

I need solution on it please reply

[Altrea]

MariaDB is a port driven application. So it can only listen on a port of an ip address available by a NIC registered on the operating system the application is running on.
Short: MariaDB can only listen on a LAN IP or IP by an virtual NIC like the loopback adapter.

Everything else is not in responsibility of MariaDB. So to make MariaDB available from the internet, you need to start at the very first entry point it hits, like an internet gateway or some sort of Router or Firewall. you need to forward the port or IP to your internal MariaDB host LAN ip address and port.

[chinmayborkar3]

I have Already setup the firewall related things.

As you said, "you need to forward the port or IP to your internal MariaDB host LAN ip address and port".

How can I Set the Ip. In which File I have to do this configuration ?

[Nobbie]

How can I Set the Ip. In which File I have to do this configuration ?

In your router. It depends on your router where and how to set it. Most routers have a menu like "Forwarded Ports" or similar. The router also should have a screen where it shows all connected PCs and their LAN IPs. You have to forward the port 3306 to the PC running MariaDB.

BUT: Running an SQL server (like MariaDB) not on the same computer (i.e. localhost) or at least not in the same LAN, but instead remote via Internet on another PC is extremely slow and a huge bottle neck. I cannot recommend to do so. Any SQL command which results in a big table will have lots of internet traffic based I/O which is way slower than TCPIP on LAN or localhost. You really *should* run the main scripts (PHP or whatever) on the same server or LAN as the MariaDB server.

[chinmayborkar3]

Hi,
I can't understand how we can Set Xampp on public IP.

Can you please explain in details and easy way.

Thanks
Chinmay Borkar

[Nobbie]

Who is "we"?
Which part of my explanation you dont understand?
What did you try, what happens?
Are you using a router? Which one?

Actually, you dont need to do anything in Xampp. You have to configure your router properly.