Installing phpBB - Problem's

[Samurai]

I ran into this a while back when I first came to use phpBB and I remember it driving me crazy back then. I did manage to fix the problem but until now, I never needed to install another forum...

Basically I've created a database in mysql, called 'forum'. This means that my forums will be located at http://www.mysite.com/forum/ - so far so good.

I then created a user to access this database, which, again went well. The user name is 'samurai' with all permissions set.

Next was the installation of phpBB. A folder was created called 'forum' in the correct place and phpBB was installed into it via ftp.

I can access every file fine via ftp.

Now when I go to install the forums using the built in phpBB installer, this is where the shit hits the fan...

Here's the screenshots:







As you can see I've put the correct info in the right fields but I'm still getting these errors no matter what I change or alter.

Does anyone know how to fix this?

I know there's not a problem with the installation or any of the files so it's not that.

Help

[Samurai]

Alright I know there's people in here that uses phpBB so stop hiding this is important

[Illuminati]

The green covered areas in the first screenie is your account name, right?

You need to include that bit at the start in the database name & username. e.g. if my account was "ill", cPanel would add "ill_" to database name & username. Hence, I'd put in "ill_database" and "ill_username" in the relevant areas.

Just a case of putting it in exactly as it says - Hope that helps

[Samurai]

yes i've tried that and it didn't work

i've tried all sorts of ways. it's definatly the 'database configuration' but i just don't know what it could be.

i've tried xxx_samurai, samurai_xxx, xxx, samurai

also tried forum_xxx, xxx_forum, forum

that didn't work either

[Illuminati]

Server - localhost
Database Name - xxx_forum
Database Username - xxx_samurai
Database Password - (whatever password you chose)
Prefix for tables - (Don't touch)

Try them exactly (substituting the xxx for your account of course) and post the errors you get if any

[Samurai]

Warning: mysql_connect(): Access denied for user: 'xxx_samurai@localhost' (Using password: YES) in /home/xxx/public_html/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/xxx/public_html/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/xxx/public_html/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

xxx = account. i would post it but it's a friend's account.

[Samurai]

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:xxx_forum:localhost","xxx_samurai","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "xxx_samurai", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("xxx_forum");

Aarrrrgh!!! Connection strings are exactly how my installation settings are and is still refusing me access.

I'm running out of ideas

[ObiWan]

try:
mysql_select_db ("xxx_forum", $dbh);

[Formula1]

are you sure you put XXX_forum as your database name during installation of phpbb ? not just forum ?

[SuperScript]

The green covered areas in the first screenie is your account name, right?

You need to include that bit at the start in the database name & username. e.g. if my account was "ill", cPanel would add "ill_" to database name & username. Hence, I'd put in "ill_database" and "ill_username" in the relevant areas.

Just a case of putting it in exactly as it says - Hope that helps

This is correct and it should work.

Are you incorrectly typing in your DB password?