Tuesday, December 01, 2009

How to access mysql from outside of localhost 127.0.0.1 in Xampp

Xampp is a great tool if you want to setup a mock web server in your local computer. You don't have to go through the hassle of downloading and installing all the server in this great little mash up. For me personally, it was more than enough for local testing. However recently I have expanded some of my boundaries and now I require to have multiple access of a single database in my local network. This is how you do it.

Navigate to your Xampp installation directory, then goto the mysql/bin directory, in my case it is
C:\xampp\mysql\bin

open the file

my.cnf


Then find the line bind-address:127.0.0.1
If it is not there then add it, and replace 127.0.0.1 with the ip address of the computer you want to access the database from. You should now be able to access your mysql server from another computer than other localhost.

No comments: