i'm using iis on windows 2k3.
i have php installed (5.2.6) with zend optimizer 3.3.3, mysql installed (5.0.67-win32) and phpmyadmin installed (2.11.8.1)
php can connect to mysql ok. i have the config.inc.php file configured with
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '*******'
this being the account setup to manage mysql.
if i try to connect to http://localhost/phpMyAdmin/index.php i get
error #2004 - can't create tcp/ip socket (5)
if i change the auth type to http, the page will now load ok, but show the user as the username logged into windows, not the user set in config.inc.php.
if i change the auth type back to config, the page again loads ok, and shows the user as that in config.inc.php, which is what is required, it also displays the list of databases configured in mysql.
but if all of iis is restarted, or the defaultapppool is restarted, i again get the #2004 error, and must change the auth type to http, reload the page, change back to config, and reload the page again.
all that's list under defaultAppPool is default application, the path is <default web site>
i can stop and start the default web site without problems, it's only when all of iis or the defaultAppPool is restarted i have to edit the config.inc.php file.
why is this happening? and what do i need to do to get the config authentication working properly.
thanks
lee.