5 replies to this topic

[404]

I'd like to setup an Apache server for my LAN network, so that all
computers can have full access to the MySQL database.
I don't have any experience with manually setting up Apache, PHP,
and MySQL, as I always used XAMPP before. Should I just install
XAMPP on a shared folder of the LAN?
Thanks.

[TheHydroImpulse]

Depends of what OS your gonna use! From the looks of it it's gonna be windows. You can very well install XAMPP on any pc in the house. Then you'll need to set your computers local ip to a static one, otherwise every time you restart your machine, or reconnect to the internet, the ip will change and it's a pain. Then you'll be able to type that machines ip address from anywhere in your network. You'll then have a lan apache server. You might also want ftp so you can edit files from different computers in your house, which filezilla server comes built into XAMPP.

Hope this helps.

[RoyalMooseTechnology]

You should set up Ubuntu Server on it.

[topdown]

You can leave XAMPP where it is and just modify the hosts files on the PCs on your network.
On Windows its typically in C:WindowsSystem32driversetchosts

Just edit these hosts files on the PCs without the XAMPP install
Eg.

192.168.1.10		localhost   # localhost is the domain to access, the IP is from your XAMPP PC

This is the easiest way without getting into bind and DNS.

You can do the same whether your server is Ubuntu, XAMPP, WAMP, etc...
Its all the same.

[sim72]

Quote

all computers can have full access to the MySQL database.

If you want to have full access you have to edit MySQL configuration file my.ini|my.cnf|my.conf
In [mysqld] insert/edit
bind-address = 0.0.0.0

After you restart the server you can access your datadase from excel, openoffice, netbeans, etc.
If you will use root account, this user will have full rights.

[hosam]

well I could suggest you to use WAMP cause it has put online feature without need to update or install any difficult parts to do the same job, and here in your situation I suppose after you put it online then you'll allow all users at your LAN to connect your server (apache) they could access this server by using your ip then your server port at their browser to get access to server data or use also these information in any program you want to get access to particulate part of your data with ip:port of your server. also WAMP has no big diffrence when compared to XAMPP in general,so you can use it if you can't use complicated installation to do the job.