PhpMyAdmin auth_type http

Problems with logging in to PhpMyAdmin

[tigertwo]

Hi,

I have joined the forum in the hope that someone can help - I have been at this all day now.

I have installed MySQL and phpmyadmin (ver. 2.8.0) onto my dedicated server which is Windows 2003. But I cannot for the life of me work out why it won't let me log in when I set the auth_type to http. Due to the lack of config.inc.php file (and the fact I couldn't seem to get setup.php to work) I created my own, however the only way I can log into phpmyadmin is by setting the auth_type to config, and putting my username and password in the config.inc.php file which isn't particularly secure at all.

Because I run most of my client's websites off this server, it is really important that I have it passworded, but when I set the auth_type to http, I get the login dialog box, which, when I put in the username and password, refreshes again, and again, and again and eventually tells me I am not authorised to view the site? I don't know what to do? I have tried both the root user and another one that I set up from the command line in MySQL and both do the same thing.

Please can someone help?

[eelixduppy]

Welcome to WebmasterWorld!

You may be able to find some answers here [phpmyadmin.net]

[tigertwo]

Thank you - but nothing seems to work. I have gone through the documentation, and done everything they have said. So clearly I have done something wrong, and I just don't know what it is. I just keep getting the login box when I enter my username and password and eventually am told that I am not authorised to view the page.

I don't know what else to do?

[jatar_k]

so I looked at the docs (wow are they slow) and found this

'HTTP' authentication (was called 'advanced' in older versions) ($auth_type = 'HTTP') as introduced in 1.3.0 allows you to log in as any valid MySQL user via HTTP-Auth.

seems strange.

why not just use the other method mentioned

If you are using the auth_type "config", it is suggested that you protect the phpMyAdmin installation directory because using config does not require a user to enter a password to access the phpMyAdmin installation. Use of an alternate authentication method is recommended, for example with HTTP–AUTH in a .htaccess file or switch to using auth_type cookie or http.