Access to remote Wamp under phpMyAdmin

The WAMP environment is a very good 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 the site development, the database is on the other server, then wamp how to access the question?

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

wamp2.5 (32bit) environment

Integration Environment Version number (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. Change the configuration file according to the following "--"; IP 192.168.1 agrees to access phpMyAdmin IP segment, setting require all granted means agreeing to all IP access.

<directory "c:/wamp/apps/phpmyadmin4.1.14/" >   Options Indexes followsymlinks multiviews   allowoverride All  <ifdefine apache24>    Require local    #--> change 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. Take the first step in the Wamp2.5 environment;

2. Change the configuration file according to the following "--"; IP 192.168.1 agree to access phpMyAdmin IP segment, set Allow from all意味同意全部IP訪问 ;

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

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

Access to remote Wamp under phpMyAdmin