Solved

accesss to phpmyadmin from WAN

Posted on 2010-09-20
6
670 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
6 Comments
 
LVL 3

Expert Comment

by:lazypeople
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
MOds:  I would recommend PAQ and refund.  This is a good solution, and I hate to let it erased.  Cheers.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Hi, in this article I'm going to teach you how to run your own site, and how to let people in (without IP). I'll talk about and explain each step... :) By the way, everything in this Tutorial is completely free and legal. This article is for …
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

763 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now