Help setting up mysql / phpbb

Have installed mysql 5 and have set the password by using

SET PASSWORD FOR root@localhost=OLD_PASSWORD('pass');

Something still isnt right though. trying to set up a phpbb forum on my apache server.

I get the errors.

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\PHP\phpBB2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\PHP\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database


It accepts my password ok, if i put a wrong password in i get an additional error.

Using the following details.

Database Server Hostname / DSN: = localhost
Your Database Name: just put dbphpbb not sure about this one
Database Username: = root
Database Password: the password i set through SET PASSWORD FOR root@localhost=('pass');

Seems like it isn't accepting the username, or maybe i have some security restrictions to set or maybe i have to create a database or something first, bit lost.

thanks for any help.

What version of phpBB? Can you connect to the database from the command line mysql client? I'm not sure phpBB supports MySQL 5, would have to check their website to confirm.

Hi,

As far as I know, phpBB doesn't support MySQL 5.x yet.

That might be the reason you're getting those errors, though I'm not a developer.

Regards,

As far as I know...phpBB is compatible with mySQL 5.x

You're right. Now I had some time to investigate a bit further.

*Official* support since version 2.0.19

And here is a previous post from phpBB forums (posted on Nov 29, 2005) explaining how to fix some minor issues when using MySQL 5:

http://www.phpbb.com/phpBB/viewtopic.php?t=345312

Regards,

Jaime