Tag Archives: allow

How to access XAMPP from external address – HTTP and MySQL

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