phpMyAdmin doesn't prompt for login

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
tbbd
Forum Newbie
Posts: 20
Joined: Sat Apr 22, 2006 2:54 pm

phpMyAdmin doesn't prompt for login

Post by tbbd »

feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


I have wxp with ISS

Installed php4, can load php files from the localhost root...php installation running ok

Installed MySql5, have it running as windows service, can connect to the server from command prompt and create  new database, create users, etc ... mysql installation running ok

Installed phpmyadmin (extracted the folder to the wwwroot folder and renamed to just phpMyAdmin), ran the setup script and added a server, using http authentication...here is the config file

Code: Select all

/* Servers configuration */
$i = 0;

/* Server localhost (http) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'MY PASSWORD';
$cfg['Servers'][$i]['auth_type'] = 'http';

/* End of servers configuration */
Attempt to access http://localhost/phpMyAdmin/index.php and it gives me "You are not authorized to view this page" error. Never even get a login prompt.

Not sure what to do next

**edit, update: I thought it may be an issue with my php installation, when I did a mysql_connect function in a php file, it gave me the error "Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client" , so I did some research and found this link: http://dev.mysql.com/doc/refman/5.0/en/old-client.html
From that I reset the pwds to the old pwd method, stopped the service, added the startup options for the old pwd and restarted it, now the mysql_connect function works from a php file and I get no errors from the page, however I still have the same issue for the phpMyAdmin error, still get no login prompt


feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

Try changing $cfg['Servers'][$i]['auth_type'] to 'config'; ( Make sure you set $cfg['blowfish_secret'] to some value. )
tbbd
Forum Newbie
Posts: 20
Joined: Sat Apr 22, 2006 2:54 pm

Post by tbbd »

Yeah, that works, but the reason I was wanting to use http is so I would get prompted to login, there will be different users with different levels of access, I don't wanna have to change the id/pwd in the config file everytime I want to login as a different user.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Afaik the http authentication only works with apache (and php as module).
Post Reply