[Resolved] how to stop viewing database directly with phpmyadmin?

[phpsharma]

Hi,

I have installed phpmyadmin on mysite and working properly. But it showing directly all the databases directly on mysite. if any one clicks www.mysite.com/phpadmin they can see all my databases and even delete all my databases. how to prevent this.

I want to have login page. Is any option available in PHYmyadmin package to do this or to writing our own code on the top of index.php.

please shed some light on this

sharma

[mrhappiness]

either you take a look at your config.inc.php or how it's called (should be in phpmyadmin root directory)

or you play around with .htaccess

[phpsharma]

By putting the below code on top of Index.php

---

<?php
function authenticate() {
header('Content-Type: text/html; charset=' . $GLOBALS['charset']);
header('WWW-Authenticate: Basic realm="Test Authentication System"');
header('HTTP/1.0 401 Unauthorized');
echo "You must enter a valid login ID and password to access this resource\n";
exit;
}

if (!($SERVER['PHP_AUTH_PW'] == "username" && $SERVER['PHP_AUTH_USER'] == "password")) {
authenticate();
} else {

---

Phpmyadmin index file code comes here

---

}

---

sharma