Assuming that your internal firewall is open (this is not the right thing to do BTW). you can open a connection from any IP address to your XAMPP server. This small tutorial will take you through the changes that you will need to do in order to be able to access XAMPP host and MySQL remotely.
for Apache go to the following line “c:\xampp\apache\conf\extra\httpd-xampp.conf” and do a search for “<LocationMatch”. Once you find it, make a change to the “Deny from all” to have a # in front of it. See code below.
<LocationMatch "^/(?i:(?:xampp|security|licenses|phpmyadmin|webalizer|server-status|server-info))"> Order deny,allow #Deny from all Allow from ::1 127.0.0.0/8 ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
Now the next thing is to fix MySQL
Once you find the “my.cnf/my.ini” file, open it up and find the line that has “[mysqld]”. Under that set of line add skip-name-resolve. This should fix the issue. Note that once you enable this, you might have some issues if you are trying to login on MyPHPAdmin. See code for example.
# The MySQL server [mysqld] port= 3306 socket= "C:/xampp/mysql/mysql.sock" basedir="C:/xampp/mysql" tmpdir="C:/xampp/tmp" datadir="C:/xampp/mysql/data" pid_file="mysql.pid" skip-external-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log_error="mysql_error.log" skip-name-resolve
Sources:
Apache Friends Support Forum • View topic – How to access XAMPP from external adress
XAMPP MySQL Server Remote Access
MySQL: Can’t get hostname for your address