Help setting up mysql / phpbb

  • drew12
  • Born
  • Born
  • drew12
  • Posts: 1

Post 3+ Months Ago

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.
  • eWebtricity
  • Novice
  • Novice
  • User avatar
  • Posts: 23
  • Loc: Tampa, Florida

Post 3+ Months Ago

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.
  • Apolo
  • Born
  • Born
  • Apolo
  • Posts: 2

Post 3+ Months Ago

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,
  • corduroy090
  • Beginner
  • Beginner
  • corduroy090
  • Posts: 53

Post 3+ Months Ago

As far as I know...phpBB is compatible with mySQL 5.x
  • Apolo
  • Born
  • Born
  • Apolo
  • Posts: 2

Post 3+ Months Ago

corduroy090 wrote:
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

Post Information

  • Total Posts in this topic: 5 posts
  • Users browsing this forum: No registered users and 30 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.