WampServer

I have been using WampServer for quite a long time and want to
add password to it so that only valid user/s would be able to access it.
But whenever I add password to it, I cannot access MySQL and the PHP.
Kindly help please.
Also how to acces the wampserver from another PC on LAN/WAN?

I have been using WampServer for quite a long time and want to
add password to it so that only valid user/s would be able to access it.

Sorry you are going to hae to expand your requirement as I dont understand what are actually trying to achieve.


But whenever I add password to it, I cannot access MySQL and the PHP.
Where are you adding a password?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Please, I am using Windows 8. 64bit O/S
I tried adding password in the phpMyAdmin and also using command line
but all failed.
LAN and WAN: I would like to be able to access whatever is on my local
PC WampServer when I am using another PC.
Thanks!

Hi blessgate,

Ok, so WAMPServer is configured to be a developers personal copy of a site or sites they are developing or maintaining. So by default Apache and MySQL are configured to only allow connections from the PC running Apache and MySQL.

If you wish to access your sites from another PC you have to tell Apache that it is allowed to accespt connections from these other PC's

The quick and dirty solution is to use the wampmanager menus to allow this access like so :-

wampmanager -> Put Online


This will change the httpd.conf file to allow access from ANY ip address in the world.So thats why its considered dirty as if you ever open up your router all your sites will be accessible, including the WAMPServer homepage. This is NOT GOOD from a security point of view.


The better solution would be to leave WAMPServer Offline, and manually edit the httpd.conf file to add lets say just the other PC's in your local area network i.e. all PC's inside your router.

To do this :-

Edit httpd.conf

Find this line

#   onlineoffline tag - don't remove
    Require local

And add to that entry the other PC's you want to allow access

#   onlineoffline tag - don't remove
    Require local
    Require ip 192.168.1.100
    Require ip 192.168.1.101

If you want to allow any IP in that range then you can do it in one command like so

#   onlineoffline tag - don't remove
    Require local
    Require ip 192.168.1

by just entering the first 3 of the quartiles of the ip address's i.e. all the ips in that subnet


Allowing access to phpMyAdmin from another PC
To do this you need to manually edit the phpMyAdmin config file \wamp\alias\phpmyadmin.conf in that same way as above, by adding to the existing security config

Alias /phpmyadmin "d:/wamp/apps/phpmyadmin4.1.14/"

# to give access to phpmyadmin from outside 
# replace the lines
#
# Require local
#
# by
#
# Require all granted
#

<Directory "d:/wamp/apps/phpmyadmin4.1.14/">
   Options Indexes FollowSymLinks MultiViews
   AllowOverride all
  <IfDefine APACHE24>
    Require local
    Require ip 192.168.1        <-- add here for Apache 2.4
  </IfDefine>
  <IfDefine !APACHE24>
    Order Deny,Allow
    Deny from all
    Allow from localhost ::1 127.0.0.1
    Allow from 192.168.1       <-- add here for Apache 2.2
         
  </IfDefine>
  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360
</Directory>

Now as all the pre-configured user account on MySQL are configured to allow access only if you are on the same PC that is running MySQL you also need to create a new MySQL account that can be used from another PC on the network.
So using phpMyAdmin, create a new user account and give it a domain of 192.168.1 as well

I think its a good idea to create seperate accounts for each user you want to access MySQL but you can get away with just one if that suites your needs.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 11/11/2014 10:56AM by Otomatic.