Access Remote Wamp under phpMyAdmin

The WAMP environment is an excellent webservice integration environment, and its integrated phpMyAdmin is also a very good database access software. Wamp default installation, the phpMyAdmin tool can only be used locally, in web development, the database is on another server, then wamp how to access it?

Article brings up "How to access phpMyAdmin under remote Wamp?" ”

wamp2.5 (32bit) environment

Integrated environment version (apache:2.4.9 mysql:5.6.17 php:5.5.12 phpmyadmin:4.1.14 sqlbuddy:1.3.3 xdebug:2.2.5)

1. In the Apache Environment phpMyAdmin configuration file phpmyadmin.conf, locate the following code:

<directory "c:/wamp/apps/phpmyadmin4.1.14/" >   Options Indexes followsymlinks multiviews   allowoverride All  <ifdefine apache24>    Require local  </IfDefine>  <ifdefine! Apache24> Order Deny,allow Deny from all to allow from  localhost:: 1 127.0.0.1</ifdefine>  Php_ Admin_value upload_max_filesize 128M  php_admin_value post_max_size 128M  php_admin_value max_execution_ Time  php_admin_value Max_input_time 360</directory>

2. Modify the configuration file as follows "--"; IP 192.168.1 allows access to phpMyAdmin's IP segment, and setting require all granted means allowing all IP access.

<directory "c:/wamp/apps/phpmyadmin4.1.14/" >   Options Indexes followsymlinks multiviews   allowoverride All  <ifdefine apache24>    Require local   #--> condition line    Require IP 192.168.1 </IfDefine>  <ifdefine! Apache24> Order Deny,allow Deny from all to allow from  localhost:: 1 127.0.0.1    </IfDefine>  php_admin_value upload_max_filesize 128M  php_admin_value post_max_size 128M  php_admin_value max_ Execution_time  php_admin_value max_input_time 360</directory>

Wamp2.4 (32bit) environment

1. Refer to the first step under the Wamp2.5 environment;

2. Modify the configuration file as follows "--"; IP 192.168.1 allows access to the phpMyAdmin IP segment, set Allow from all意味允许所有IP访问 ;

  <ifdefine! apache24>    Order Deny,allow Deny from all allow from  localhost:: 1 127.0.0.1                    #--> Modify line          allow From 192.168.1 </IfDefine>

The configuration of the P.S Wamp environment is dependent on the Apache version of the wamp2.5 and the wamp2.4 configuration is different because the dependent Apache version is not the same!!!

Access Remote Wamp under phpMyAdmin