PHPBB2, Database Password

Changing the Password used to connect to the database.

[silk]

I am an admin for a phpbb2 v2.0.8. I'm not absolutely sure which username/password is being used to connect to the mysql database. Is there any way i can determine this and change it without adversely affecting the board?

[EliteWeb]

Look in the config file normally located in the root of the folder phpBB is in. The information is in plain text. ie: config.php

// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql';

$dbhost = 'localhost';
$dbname = 'yourBBuname';
$dbuser = 'userNameHere';
$dbpasswd = 'passw0rdhere!';

$table_prefix = 'phpbb_';

If you change it in the config file you will need to change it in mySQL. Your system administrator can assist with changing in mySQL or if you have phpMyAdmin installed for web-based access the option is within there.

[encyclo]

Slightly off-topic - you need to update that PHPBB version to the latest (currently 2.0.10) - there are some nasty bugs in the older versions which could allow an attacker to take over the board.

[phpbb.com...]

[silk]

Muchas Gracias! Will do.!

[silk]

Whew. Ok. I administer 2 phpbb boards. Now i went thru the config file and changed the user and password, but i get a critical error: "could not connect to database".

Ok, i went thru the phpMyAdmin2.5.6 and cannot find anywhere to change the username and password in mysql.

Granted, there is a frontend, a database manager,where i can add users and set their roles. I did use a user from there in the config file, but it still doesn't work. So how do i get to use another user.

BTW, it was the "database administrator" user that connects to the database. I'm trying to set it to a RW user.

Thanks again in advance.

[EliteWeb]

Will need to log in again and find privledges as an option for me its [domain.com...]

You may not have enough permissions to change your password but should.

[silk]

Ok thanks. I think i'll contact my webhost for a lil guidance there.

Thx for all the help though.

-- growing in experience --