How do I lock phpMyAdmin so only my IP can access it

Hi All

I want to lock my phpMyAdmin installation so that only my IP's can access this part of my server, not sure how to do it myself and googing returned crud - any help appreciated.

Thanks

Mikey

 

the only way I have seen this done so far is to add an extra couple lines of code in you phpmyadmin files. depending on how many files need to be edited this will cost money.

 

I was pretty sure i could do it with htaccess?

 

Hello,

try to update your .htaccess with the following statements:

order deny,allow
deny from all
allow from your_ip_address

Regards
Thibaut

 

Hi Thibaut

I have tried this and it locks me out from the directory presenting me with this error page:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Hello m8,

try to add this statement:

AddType x-mapp-php5 .php

Regards
Thibaut

 

Hi Thibaut

My .htaccess file now reads

AuthName "phpMyAdmin Area"
AuthType Basic
AddType x-mapp-php5 .php
<Limit GET POST>
order deny,allow
deny from all
allow from 86.153.160.174
</Limit>

but still not letting me into the directory

 

hmmmmm i'd say change the ip to localhost, and try accessing phpmyadmin from localhost maybe that'll do the trick!