Resetting a Concrete5 Password from phpMyAdmin

If your email configuration is broken in Concrete 5 and you need to reset the password manually this is how.

Locate the file:

config/site.php

You’ll see a define for PASSWORD_SALT:

define('PASSWORD_SALT', 'SOMERANDOMSTRING');

• Login to the database for Concrete 5 in phpMyAdmin and
• Select the users table,
• Edit the admin user.
• Next to the password field there’s a function drop down, select md5 in this.
• Enter your new password followed by a colon (:) and then your password salt.

  newpassword:SOMERANDOMSTRING
  

• Save the user.