Page 1 of 1

phpMyAdmin doesn't prompt for login

Posted: Sat Apr 22, 2006 3:16 pm
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]

Posted: Sun Apr 23, 2006 4:53 am
by anjanesh
Try changing $cfg['Servers'][$i]['auth_type'] to 'config'; ( Make sure you set $cfg['blowfish_secret'] to some value. )

Posted: Sun Apr 23, 2006 7:14 pm
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.

Posted: Mon Apr 24, 2006 6:19 am
by timvw
Afaik the http authentication only works with apache (and php as module).