Yogi
July 5th, 2007, 18:49
I have a phpbb forum that has been working fine for a couple years. I added a mod a long time ago that requires a password to get to its control panel. There is now a need for me to get into the control panel again, but I forgot the password. The password is stored in hashed form in a simple configuration table in the database. All I need to do is change the value of the hash (I presume), but I forgot enough about SQL to make me hesitant to experiment on my live board.
Can anyone suggest the SQL code I could use to change a single value in a two column table?
The table is called config, and has columns called config_name and config_value. I need to change the config_value entry for the appropriate password record. I'm pretty sure they are using at least MySQL 4 and they provide a handy phpMyAdmin interface to work on the database. So, it should be easy if I had the right coding. Can anybody help?
Can anyone suggest the SQL code I could use to change a single value in a two column table?
The table is called config, and has columns called config_name and config_value. I need to change the config_value entry for the appropriate password record. I'm pretty sure they are using at least MySQL 4 and they provide a handy phpMyAdmin interface to work on the database. So, it should be easy if I had the right coding. Can anybody help?