Recover Administrator Password

[Pavel]

Hello,
Could you tell me how can I retrieve my admin password?

I did not remember changing it, but I cannot login now. ListMail reports “Incorrect password”.

[DW]

Currently this is possible via PhpMyAdmin, likely accessible from your control panel.

Click on the "lm_config" table and hit "Browse", then look at the value in the "admpw" field.

Another way would be by copying the following code into a file in your ListMail directory, ie "recover_password.php":

Code: [Select]

<?php// show admin password from ListMail$listmail_dir = ".";include($listmail_dir."/config.php");include($listmail_dir."/admin.php");$link = mysql_connect($sqlhost, $sqluser, $sqlpass) or die("Can't connect to MySQL");mysql_selectdb($sqldb) or die("Can't select database, does it exist?");echo "retrieving password.. ";$row = mysql_query("select admpw from $ctable where 1");if(mysql_num_rows($row)>0){	list($pw)=mysql_fetch_row($row);	echo "  your password is <b>$pw</b><br>";} else {	echo "<b>  could not read config!</b><br>";}?>

Upload it to your main ListMail folder and browse to it, you should be shown your password.

[Pavel]

Success!

Thanks Dean, Ive used first method and everything went smooth.

Please include your piece of code to the new addition of ListMail as a small secret utility for all admins to use if they lost their passwords.