How do we set up password for PhpMyAdmin

[newcomer]

Hi All!

I have phpmyadmin running but how do we set up user and password for this so whenever we want to use it then we must enter user id and password?

Thanks in advance.

[NMS]

you can use htaccess since it is on a separate directory. Check out help.powweb.com/tutorials/

[SLSTEK]

newcomer -- Let me tell you how I do it.

I ordered the Powweb MySQL database package ($10) and I presume you have already done that and know what your server's name is (something like callisto.powweb.com), know the name of your data base, and the username and password of your database.

After you install phpMyAdmin, you can do this on a local website you have control of or on powweb's site.

Read the notes in the phpMyAdmin Documentation.html file.

Basically, you will have to edit the config.inc.php file in the phpMyAdmin root directory and update this info to "match" your server hostname, username, and password for your database.

Need to update this one:
$cfg['PmaAbsoluteUri']

then this one:
$cfg['Servers'][$i]['host']

and this one:
$cfg['Servers'][$i]['user']

and then this one:
$cfg['Servers'][$i]['password']

I have tested both ways (either running locally and remote on powweb server and even both at the same time :) ), but now run mine locally from my own computer (XP+IIS installed internally behind a firewall), but it still lets me connect remotely to manage the Powweb MySQL databases (and others too, are selectable), etc., and does not consume 4 Mbytes of disk space on the Powweb server, reduces monthly HTTP bandwidth on my powweb account, plus a little more protection and security (IMO).

If you choose to install and run phpMyAdmin on your Powweb server location, then I would also recommend putting it in a directory with a name other than phpMyAdmin and then .htaccess + .htpasswd password protect (extra directory's username and password) the directoty as well for security reasons.

Best of luck!