phpMyAdmin asking for server password

drumdogg · 11 Apr 2013 at 12:37

Hi Guys,

When I hit the link to connect to phpMyAdmin on my PC (Client) it asks for the server username and password that it is install on before i get to the login screen.

Is there a way that i can stop it asking for the server password??

Is there something i need to change in the config.ini file possibly??

Thanks

doiks14 · 11 Apr 2013 at 15:13

If you go to where phpmyadmin directory is there should be a file named config.sample.inc.php.

Open it in a text editor and add/make sure you have the following lines

Code:

$cfg['Servers'][$i]['user']      = 'root';
$cfg['Servers'][$i]['password']  = 'yourpassword';

and change the auth type to

Code:

$cfg['Servers'][$i]['auth_type'] = 'config';

and then save it as config.inc.php in the same directory

drumdogg · 11 Apr 2013 at 16:16

Hi doiks14,

Have tried what you said and still doesn't work

Still asking for password

Redrum · 11 Apr 2013 at 19:21

Is it phpMyAdmin that is asking for the password or the web server software? If you're not sure, post a screenshot.

doiks14 · 11 Apr 2013 at 19:24

Redrum said:
Is it phpMyAdmin that is asking for the password or the web server software? If you're not sure, post a screenshot.

+1
A screenshot would give us more of an idea of your problem

drumdogg · 12 Apr 2013 at 08:47

It is phpMyAdmin asking for the password of the web server.

A login box appears saying connecting to 192.168.X.X (Which is my web server)
Once i type in the password of the login to the server to proceeds to the phpMyAdmin login screen.

Will try and post a screen shot later on.

Cheers

Deleted member 77746 · 12 Apr 2013 at 09:10

by default if you download from the phpmyadmin website;
http://www.phpmyadmin.net/home_page/index.php

You shouldn't have to alter anything to be able to login. The login will be based on your default SQL admin username and password that you set up with MYSQL.

drumdogg said:
It is phpMyAdmin asking for the password of the web server.

A login box appears saying connecting to 192.168.X.X (Which is my web server)
Once i type in the password of the login to the server to proceeds to the phpMyAdmin login screen.

Will try and post a screen shot later on.

Cheers

Judging by this quote it could be http directory login that it's asking for not phpmyadmin. Remake a folder in root and put a new install of phpmyadmin inside there and try again, get a screenshot.

drumdogg · 12 Apr 2013 at 14:56

Judging by this quote it could be http directory login that it's asking for not phpmyadmin. Remake a folder in root and put a new install of phpmyadmin inside there and try again, get a screenshot.

Still same issue when installed new version.

Here is the issue i am having - http://tinypic.com/view.php?pic=o94gtz&s=6

Redrum · 12 Apr 2013 at 20:28

The Windows Security box in your screenshot is not a phpMyAdmin password prompt so I suspect this doesn't have anything to do with phpMyAdmin and if so whatever HTML or PHP files you put there, you'd get the same problem.

I'd try a different browser and if you still get prompted for a password, I'd say it's a password on the directory by the web server as mrbell1984 suggested, although the curious thing is in your screenshot, phpMyAdmin seems to have loaded in the background. I assume you can't just close that prompt and use phpMyAdmin... The phpMyAdmin login page behind the Windows Security box is where you would enter your MySQL username and password.

As for the message, do you know what web server you're using? If it's Apache, look for a file in the directory called .htaccess. If it's MS IIS or something else, then someone here who knows about Windows will probably be able to tell you where to look in the settings.

Deleted member 77746 · 13 Apr 2013 at 16:18

That screenshot is a server config problem on that directory. As Redrum already asked what server are you using for www.

doiks14 · 13 Apr 2013 at 16:34

Looks like it's running Microsoft IIS by the looks of the login popup (unless IE is really weird). Do you have access to the server? I'm assuming you do as it's a local network address.

If so, check IIS settings, make sure you allow access to anonymous users.

check here http://www.iis.net/learn/manage/configuring-security/understanding-iis-url-authorization

drumdogg · 15 Apr 2013 at 08:38

Looks like it's running Microsoft IIS by the looks of the login popup (unless IE is really weird). Do you have access to the server? I'm assuming you do as it's a local network address.

If so, check IIS settings, make sure you allow access to anonymous users.

Yea it is IIS 6 on an old 2003 Server i am using. The only settings under IIS that i can change to do with phpMyAdmin is under Application Pool. phpMyAdmin is added to the Application Pool, is this the correct way to set it up??

In properties under the 'identity' tab i have set it to use a username and passsword of the server but this still doesnt work for me.

Deleted member 77746 · 15 Apr 2013 at 08:57

drumdogg said:
Yea it is IIS 6 on an old 2003 Server i am using. The only settings under IIS that i can change to do with phpMyAdmin is under Application Pool. phpMyAdmin is added to the Application Pool, is this the correct way to set it up??

In properties under the 'identity' tab i have set it to use a username and passsword of the server but this still doesnt work for me.

http://www.microsoft.com/technet/pr...af2-fcb7-4ed2-b007-e19f971f6e13.mspx?mfr=true

IIS6 Allowing Anonymous Access to Web Sites (IIS 6.0)

drumdogg · 16 Apr 2013 at 09:58

I have allowed anonymous access to phpMyAdmin but it is still asking for a password

Deleted member 77746 · 16 Apr 2013 at 18:02

Can I ask if it's a live server or is it something you are playing with ?

drumdogg · 17 Apr 2013 at 08:15

Can I ask if it's a live server or is it something you are playing with ?

Its a live server within the company which runs an internal site that i created for them.

Server wasnt used that much so i use it for web development now.