Problems with the Windows version of XAMPP, questions, comments, and anything related.
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
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.
- AF Moderator
- Posts: 3316
- Joined: 03. October 2008 05:10
- Location: Yeppoon, Australia Time Zone: GMT/UTC+10
- XAMPP Version: 5.6.3
- 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 42 guests