Solved

accesss to phpmyadmin from WAN

Posted on 2010-09-20
6
688 Views
Last Modified: 2013-12-12
Hi
I have a simple question about phpmyadmin
I can use it on lan but not on wan

I have changed the settings to :
----------------------------------
 Order Allow,Deny
 Allow from all
---------------------------------

But i am not sure to how to access it
I am using WAMP Server so phpmyadmin is in C:\wamp\bin folder

We have about 20 virtual hosts on our server

How to I setup phpmyadmin so I can type a path in the browser and get access to it from WAN:

Regards
Morten
0
Comment
Question by:morten444
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 3

Expert Comment

by:lazypeople
ID: 33716720
Did you modify your .htaccess file? or the main apache config file you might find that the apache has limited the IP's to local IP's for that directory. for security reasons.
0
 
LVL 34

Expert Comment

by:Beverley Portlock
ID: 33716799
On ours we deny all IPs except an approved list of IPs

Order Deny,Allow
Deny from all
Allow from 111.222.333.444
Allow from 11.22.33.44
...etc

It means that you have to use static IP addresses but it keeps the hackers out of phpMyAdmin. Also consider changing the name of the folder (and DON'T use "pma" it is the next guess hackers try after "phpmyadmin").

If you cannot use static IPs then consider implementing an .htpasswd file with a different password from phpmyadmin.
0
 

Author Comment

by:morten444
ID: 33716902
Hi
Thanks for your replies
My problem is what do I write in the URL line to access?

I have a domain like www.eadvice.dk

Do I just move the phpmyadmin folder from C:\wamp\bin  to C:\wamp\www\domainfolder\  ?
Do i write something into the "virtual host" file?

I have tried that but does not work.
I think i have got the permission correct. problem is I dont know how to access it via an URL
0
 

Accepted Solution

by:
morten444 earned 0 total points
ID: 33720507
Found out my self
Inside the www\alias there is a phpmyadmin.conf file
I can change alias here to xxxx
then i can access phpmyadmin from www.domain.com\xxxx

0
 
LVL 15

Expert Comment

by:samri
ID: 33755378
MOds:  I would recommend PAQ and refund.  This is a good solution, and I hate to let it erased.  Cheers.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question