Solved

accesss to phpmyadmin from WAN

Posted on 2010-09-20
6
683 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

751 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