Page 1 of 1

I get an access denied error on step 4

Posted: Wed Oct 12, 2005 8:38 pm
by TimothyFoo
This is undoutably my own fault, but please forgive my lack of php/MySQL experience.

I am entering the details correctly (as far as I can tell) in step three, but I get an error on step four saying thus:

"Warning: mysql_connect(): Access denied for user: 'listn2_whomedia@localhost' (Using password: YES) in /home/listn2/public_html/simple/lib/adodb/drivers/adodb-mysql.inc.php on line 340
Connection failed"

Here is a screengrab of the details I'm entering:

[img]http://www.listnsell.co.nz/whomedia/ran ... 1.jpg"%20/>[/img]

Any ideas where I might be going wrong? I am certain I have created the database and I am certain my host has MySQL (Frollicking dolphins and all).

Thank you.

Re: I get an access denied error on step 4

Posted: Wed Oct 12, 2005 8:41 pm
by TimothyFoo
I can't seem to edit my post. Here's the scree grab again:

Image

Re: I get an access denied error on step 4

Posted: Wed Oct 12, 2005 11:30 pm
by TimothyFoo
I found another thread with a similar problem being resolved by moving to a postgreSQL database. I tried that and now I get the error:

"Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: ( Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? in /home/listn2/public_html/simple/lib/adodb/drivers/adodb-postgres64.inc.php on line 646
Connection failed"

I don't know if this information helps at all.

Re: I get an access denied error on step 4

Posted: Thu Oct 13, 2005 2:46 am
by TimothyFoo
It turns out I also need a *_ prefix on the username, as well as the database name.

I'm happliy up and running.