Welcome to WebmasterWorld Guest from 54.161.201.189

Forum Moderators: rogerd

PHPBB2, Database Password

Changing the Password used to connect to the database.

   
5:47 am on Sep 14, 2004 (gmt 0)

10+ Year Member



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?
5:58 am on Sep 14, 2004 (gmt 0)

WebmasterWorld Senior Member eliteweb is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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.

10:06 am on Sep 14, 2004 (gmt 0)

WebmasterWorld Senior Member encyclo is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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...]

3:56 pm on Sep 14, 2004 (gmt 0)

10+ Year Member



Muchas Gracias! Will do.!
5:56 am on Oct 5, 2004 (gmt 0)

10+ Year Member



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.

6:00 am on Oct 5, 2004 (gmt 0)

WebmasterWorld Senior Member eliteweb is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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.

6:36 am on Oct 5, 2004 (gmt 0)

10+ Year Member



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

Thx for all the help though.

-- growing in experience --

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month