Hello ppl
First of all i have to say that i am a totally noob about php and mysql, i just had little "novice" experience with IIS and asp.

My problem (that is driving me crazy since i am browsing the forum for the whole morning and can't find a solution that works for me) is that after Step 1 i get the error "Failed to connect to database as user@localhost" thingie, i managed to setup the new database in mysql and i can access the DB by the Mysql console.

I am running IIS 5.1 on an xp pro machine with mysql 5.0 and php 4.4.4 installed.

Can someone of you please help me? This error is driving me totally NUTS

Thanks in advance

EDIT: Update, i had my php server running in cgi mode... managed to set it in ISAPI mode, but no luck with the installation either....

Having the same problem.

I am a complete tard at stuff like this so any help would be greatly appreciated =)

Thx in advance

I am not a complete newb, but I'm having the same problem as well.

mysql --version yields:

$ mysql --version
mysql Ver 14.12 Distrib 5.0.21, for apple-darwin8.2.1 (powerpc) using readline 5.0

I am able to do:

$ mysql -u uname -ppassword dbname

(with appropriate substitutions) and can create / drop tables. But the installer gives me the Failed to connect to database error.

Okay, I found that using "localhost" for the host name doesn't appear to work. Here's the things I did.

1. From the shell, I logged into mysql as "root".

2. I ran this command:

grant all on mydbyname.* to myname@my.complete.machine.name identified by 'mypw';

3. I then specified this information in install.php:

Database host: my.complete.machine.name
Database name: mydbname
Database username: myname
Database pw: mypw

(Of course, in both steps 2 and 3, I put in real data, not fake data).

Once I did all that, i was able to get it to work. I don't know why "localhost" didn't work.