homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / WebmasterWorld / Community Building and User Generated Content
Forum Library, Charter, Moderators: rogerd

Community Building and User Generated Content Forum

PHPBB2, Database Password
Changing the Password used to connect to the database.

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

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)

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)

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.



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

Muchas Gracias! Will do.!


 5:56 am on Oct 5, 2004 (gmt 0)

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)

Will need to log in again and find privledges as an option for me its https://www.domain.com/phpMyAdmin/server_privileges.php?lang=en-iso-8859-1&server=1

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


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

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

Thx for all the help though.

-- growing in experience --

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Community Building and User Generated Content
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved