administrator forgot own password

shige1947

Hi. sorry to say that I am the admin that has forgotten my password and user name. How can I get into my forum. Any help will be appreciated. And, I did try filling out the forgot password form but never got an email. And now I am stuck.

Todd

Did you set up your outgoing email? If not you are stuck without DB access.

What I would do is edit my conf/config.php and get the email setup. Here is what you need to set:

$Configuration['Garden']['Email']['UseSmtp'] = TRUE;
$Configuration['Garden']['Email']['SmtpHost'] = 'server address';
$Configuration['Garden']['Email']['SmtpUser'] = 'username';
$Configuration['Garden']['Email']['SmtpPassword'] = 'password';
$Configuration['Garden']['Email']['SmtpPort'] = 'port'; // gmail uses 465
$Configuration['Garden']['Email']['SmtpSecurity'] = 'ssl'; // gmail uses ssl, most don't though

Todd

If you have database access then I would do the following:

1. Apply for membership again in your forum. Make sure you remember this password.
2. Set the admin flag of that new user in phpMyAdmin.
3. Reset the password of the original admin

Let's say your new user has a username of 'AdminReset'. The SQL you want is the following:

update GDN_User set Admin = 1 where Name = 'AdminReset'

WARNING: If you DON'T put that where clause in the SQL then you will give EVERYONE admin access. That would be terribly unfortunate.