database struggles (access denied to db for application install)

[timg]

Okay, I've done it successfully numerous times before, but it's a been a while (and there's been a few versions of the application in question since I last did a fresh install too).

Here's the scenario:

In cPanel, I have created a database called "wb" with the MySQL Maintenance manager. I have also created a user for the database (let's call him "bill"). As you know, this results in a format that looks like this: accountusername_wb and accountusername_bill.

Okay, so I am attempting to install the Website Baker CMS. Like I said, I've done it several times, so I thought I knew what I was facing. Anyway, on the install page, I need to fill in these fields:

Hostname (I've been putting localhost)
Username (I've tried both accountusername_bill and just plain bill)
Database name (I've tried both accountusername_wb and just plain wb)
Password (self-explanatory)
Table prefix (I've tried accountusername, accountusername_, and just leaving it blank)

Whatever I do, I get access denied errors for the user, and in addition (depending on the precise configuration above), a "Cannot modify header information - headers already sent" warning.

I need to a second pair of eyes, and a new head. I've spent hours on this already. Any fresh ideas regarding what I'm doing wrong?

Thanks in advance.

[Buddha]

Have you tried using 127.0.0.1? It shouldn't matter but ...

Might check the MySQL Account Maintenance panel is allowing localhost access.

[timg]

Have you tried using 127.0.0.1? It shouldn't matter but ...

Uh... don't know what that means. Where are you suggesting that might belong?

Might check the MySQL Account Maintenance panel is allowing localhost access.

If you're asking whether the panel is showing localhost as an Access Host, the answer is yes.

Thanks, Buddha.

[timg]

Nevermind. I finally got it. Yowsers. The particular combination that worked was:

Host name: localhost
Username: useraccountname_user
Database name: useraccountname_user
Table prefix: useraccountname_

Blech.

Hope I remember that one for next time. But at least it'll be searchable here.

[Buddha]

127.0.0.1 is the IP address for localhost and should be interchangeable. ("Should be")

Host name: localhost
Username: useraccountname_user
Database name: useraccountname_user
Table prefix: useraccountname_

That's a weird combination of values.

[timg]

127.0.0.1 is the IP address for localhost and should be interchangeable. ("Should be")

Ah. Thanks.

That's a weird combination of values.

Yeah, that's what I thought too. No wonder it took me so long to figure out. I'd better keep a record of that.

[timg]

Host name: localhost
Username: useraccountname_user
Database name: useraccountname_user
Table prefix: useraccountname_

Oops. Database name should be: useraccountname_dbname (in this case wb)