Problems with the Windows version of XAMPP, questions, comments, and anything related.


Postby rickvill » 14. March 2011 06:45

hi am using xampp.

i installed it properly on my first pc. i run the program.

the question is, how can i access the database in my first computer using onother pc via lan(local area network).

what are the settings.

Posts: 1
Joined: 14. March 2011 06:41

Re: xammp

Postby Sharley » 17. March 2011 08:22

You need to set privileges for the user of the database you want to access from the LAN PC to Any Host not localhost which is the default setting.

On the localhost PC with XAMPP installed, open phpMyAdmin using the root user and select the Privileges button from the top menu.

Click on the edit button in the end Action column of the user of a database you want to access from the LAN PC.

If you want the root user to have access (not recommended - localhost only is preferred for root) then you will have to create a new root user with these new Any Host privileges.

Scroll down to the Change Login Information / Copy User section - last section.

Find the entry for Host: and from the drop menu select Any Host and a % will be inserted in the next text box.

No need to change any other settings.

Now click on the Go button at the end of this section.

Exit phpMyAdmin and restart MySQL.

Try and access the database again.
User avatar
AF Moderator
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 80 guests