Configuring PhpMyAdmin to connect to a remote MariaDB server

Question

I have a computer within the LAN network at my workplace that hosts a MariaDB database from Xampp and accesses the database through PhpMyAdmin. It is accessible through the workplace LAN, but we need to be able to access it from an external network (a different building in another city) through the PhpMyAdmin UI.

How on earth do I configure the external client's files to connect to the database on our LAN? From my research, all I can see is how to configure it to work within the same LAN.

P粉155551728 · Answer

Because I don’t know your specific IP and parameter values, I can only give you methods. The specific method is as follows:

First of all, ensure that the network communication at both ends is normal; whether it is a public network or a VPN;
When creating a user or using alter, you need to correctly configure the host that the user accesses;