Configuring Apache Server for home network

[peterchan75]

Hi,

Let's say I have 5 PCs connected to my home network. I would like to 2 MySQL databases, database A in PC1 and database B in PC2. All the PCs are able to access to the 2 databases.

How to go about configuring the Apache servers ?

Thanks.

 

[huffie]

You referring to using phpMyAdmin on your Apache server to access the 2 databases? from my understanding, when you create a user with privilege in MySQL you can specify the ip address allowed to access.
MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 5.5.3 Specifying Account Names

 

[peterchan75]

Thanks. I haven't reached MySQL stage.
Will need to sort out the Apache setup first. I am looking at the doc now.
Apache Virtual Host documentation - Apache HTTP Server Version 2.2

 

[davidktw]

Thanks. I haven't reached MySQL stage.
Will need to sort out the Apache setup first. I am looking at the doc now.
Apache Virtual Host documentation - Apache HTTP Server Version 2.2

Apache do not normally uses the MySQL itself. It's more often that the web application that is connecting to the databases.

Only a few modules in Apache will utilised the database such as mod_authn_dbd, mod_log_dbd etc.

Look at the web application documentation, or scripting engine documentation such as PHP, Perl, etc on how the database drivers in these engines connect to the database.

 

[peterchan75]

Sorry, I didn't mention PHP. I plan is to use browser to access 2 saparate MySql databases. Will use PHP to create form/template for display and update database. Many reference books only mention the Apache server setup briefly and don't even talk about vertual host.

 

[davidktw]

Sorry, I didn't mention PHP. I plan is to use browser to access 2 saparate MySql databases. Will use PHP to create form/template for display and update database. Many reference books only mention the Apache server setup briefly and don't even talk about vertual host.

Why do you need to recreate the wheel when phpMyAdmin is already available ? phpMyAdmin does not require the use of virtual host. One instance of phpMyAdmin can already manage multiple databases.

Configuration — phpMyAdmin 4.4.0-dev documentation

 

[peterchan75]

Thanks.
Will look at it.