Failed to connect to database

Installation issues with WoWRoster

Failed to connect to database

Postby nomc2 » Tue Oct 31, 2006 3:56 pm

Hello ppl :P
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 :P

Thanks in advance :P

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....
Last edited by nomc2 on Tue Oct 31, 2006 5:30 pm, edited 1 time in total.
nomc2
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Tue Oct 31, 2006 3:46 pm

Re: Failed to connect to database

Postby doom » Wed Nov 08, 2006 7:34 am

Having the same problem.

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

Thx in advance
doom
WR.net Apprentice
WR.net Apprentice
 
Posts: 12
Joined: Wed Nov 08, 2006 7:29 am

Re: Failed to connect to database

Postby Sinny » Thu Nov 30, 2006 10:49 pm

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.
Sinny
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Thu Nov 30, 2006 10:45 pm

Re: Failed to connect to database

Postby Sinny » Fri Dec 01, 2006 2:00 am

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.
Sinny
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Thu Nov 30, 2006 10:45 pm


Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests