Wampserver configuration (Allow external access, phpMyAdmin set to enter user name password to log in, etc.)

For a lot of friends who are not familiar with the installation of PHP environment, with the integration of the environment can be faster to get started, more convenient to build PHP operating environment, but the WAMP integration environment is only the basic work done, some individual key configuration operations are not integrated into the environment installation, so to everyone brings a lot of trouble, See a lot of search engine friends are asked why the installation of Wamp, only local access? No access in LAN? Or why is local database phpMyAdmin not accessible on an external LAN? How do I set up MySQL to enter a user name and password instead of logging in directly?


According to your own hands-on practice, say WAMP configuration of the entire process.


1. Download and install:


First download wampserver from http://sourceforge.net/projects/wampserver/, I wrote this article with the latest version of Wampserver2.2d-x32.exe.


The first step is to change the language, right-click the Wampserver icon in the taskbar, and select Language-chinese.




2, ensure that wampserver work properly:


Do not let other programs occupy its default port (Apache default port 80 and MySQL default port 3306). You can open the http://localhost test and click the Wampserver icon-localhost.




3, make the website and phpMyAdmin can be accessed by the external network (by default, only local access is allowed):


First shut down the firewall (or add an exception in the firewall, anti-virus software has a firewall especially attention to close);


Then write down these two sentences in wamp\bin\apache\apache2.2.21\conf\httpd.conf (to restart the Wamp service to take effect)


Deny from all


Allow from 127.0.0.1


is changed to


#Deny from all


#Allow from 127.0.0.1


So that the external network can access the main site;


Also allow the extranet access to phpmyadmin the same changes in the wamp\alias\phpmyadmin.conf, instead


#Deny from all


#Allow from 127.0.0.1


4, the phpMyAdmin is set to enter the account password to login:


After entering the phpMyAdmin, delete the account and edit the permissions (including global permissions, passwords, login information, etc.).


At this time may find phpMyAdmin landing does not go in, need to do the following operations:


In wamp\apps\phpmyadmin3.4.10.1\config.inc.php, change to


$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; (the original is ' config ')


$cfg [' Servers '] [$i] [' user '] = $cfg [' Servers '] [$i] [' User ']= ' your username ';


$cfg [' Servers '] [$i] [' password '] = $cfg [' Servers '] [$i] [' Password ']= ' your password ';


Then restart the Wamp service, open the phpMyAdmin again, the landing screen will appear.




5, about landing phpmyadmin after landing red hint "profile now requires a phrase password" solution:




In wamp\apps\phpmyadmin3.4.10.1\libraries\config.default.php, change to


$cfg [' blowfish_secret '] = ' arbitrary string ';

Then restart the Wamp service so that you won't be prompted after logging in. But I encountered a problem: Login interface user name line garbled, although does not affect you enter the user name password login but look uncomfortable. So I didn't have to set the phrase password.

Wampserver configuration (Allow external access, phpMyAdmin set to enter user name password to log in, etc.)