ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: Pavel on June 28, 2004, 09:07:06 am

Title: Recover Administrator Password
Post by: Pavel on June 28, 2004, 09:07:06 am
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”.
Title: Recover Administrator Password
Post by: DW on June 28, 2004, 03:57:16 pm
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.
Title: Recover Administrator Password
Post by: Pavel on June 29, 2004, 01:12:43 am
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.