mysql - 通过 MySQL (phpmyadmin) 恢复密码？

Question

我有一个使用此商店代码canyon.net/item/universal-digital-shop/2987770的脚本，但是我最近通过它的管理面板前端更改了我的密码(通常基于例如yoursite.com/settings.php )并做了一个愚蠢的举动，在关闭之前不检查记事本是否确实保存了我的新密码。

现在我根本无法登录我的商店，需要帮助。

我检查了 phpmyamdin，它似乎是一个哈希密码(是 md5？)，我只是不知道它们是如何工作的。

我可以发布代码块，并且我有 mysql 和 phpmyadmin 的 root 访问权限(不过，我通过 phpmyadmin 而不是 shell 更舒服)。

我不想再次填充整个数据库，因为这会丢失我的客户记录。

有什么想法吗？

下面的代码包含密码和登录 ID。但密码“346g3643832823h2h39236323f263827”和登录ID“admin”仅用于示例目的，并不是数据库中实际的实时数据。

<?php
/** DO NOT MODIFY OPTIONS BELOW. YOU CAN MODIFY THEM VIA ADMIN PANEL. */
define('VERSION', '2.50');
define('RECORDS_PER_PAGE', '50');
define('DEMO_MODE', false);
define('STATUS_DRAFT', 0);
define('STATUS_ACTIVE', 1);
define('STATUS_PENDING', 7);
define('ABSPATH', dirname(dirname(__FILE__)));

$options = array (
"version" => VERSION,
"owner_email" => "alerts@".str_replace("www.", "", $_SERVER["SERVER_NAME"]),
"from_name" => "Universal Digital Shop",
"from_email" => "noreply@".str_replace("www.", "", $_SERVER["SERVER_NAME"]),
"success_email_subject" => "Thank you for payment",
"success_email_body" => "Dear {payer_name},".PHP_EOL.PHP_EOL."Thank you for your purchasing \"{file_title}\". Please find download link below:".PHP_EOL."{download_link}".PHP_EOL."This link is valid {download_link_lifetime} days.".PHP_EOL.PHP_EOL."Thanks,".PHP_EOL."Universal Digital Shop",
"failed_email_subject" => "Payment was not completed",
"failed_email_body" => "Dear {payer_name},".PHP_EOL.PHP_EOL."Thank you for your payment. Unfortunately, it was not completed.".PHP_EOL."Payment status: {payment_status}.".PHP_EOL."We will review your payment shortly.".PHP_EOL.PHP_EOL."Thanks,".PHP_EOL."Universal Digital Shop",
"csv_separator" => ";",
"link_lifetime" => "2",
"xsendfile" => "off",
"enable_paypal" => "off",
"paypal_id" => "",
"paypal_sandbox" => "off",
"enable_payza" => "off",
"payza_id" => "",
"payza_sandbox" => "off",
"enable_interkassa" =>"off",
"interkassa_shop_id" => "",
"interkassa_currency" => "USD",
"interkassa_secret_key" => "",
"enable_authnet" => "off",
"authnet_login" => "",
"authnet_sandbox" => "off",
"authnet_key" => "",
"authnet_md5hash" => "",
"enable_skrill" => "off",
"skrill_id" => "",
"skrill_secret_word" => "",
"enable_egopay" => "off",
"egopay_store_id" => "",
"egopay_store_pass" => "",
"enable_perfect" => "off",
"perfect_account_id" => "",
"perfect_payee_name" => "",
"perfect_passphrase" => "",
"enable_bitpay" => "off",
"bitpay_key" => "",
"bitpay_speed" => "medium",
"enable_stripe" => "off",
"stripe_secret" => "",
"stripe_publishable" => "",
"login" => "admin",
"password" => "346g3643832823h2h39236323f263827"
);
$paypal_currency_list = array("USD", "AUD", "BRL", "CAD", "CHF", "CZK", "DKK", "EUR", "GBP",
"HKD", "HUF", "ILS", "JPY", "MXN", "MYR", "NOK", "NZD", "PHP", "PLN", "SEK", "SGD", "THB", "TRY",   

"TWD"););
$interkassa_currency_list = array("USD", "EUR", "GBP", "RUR", "UAH");
$egopay_currency_list = array("USD", "EUR");
$perfect_currency_list = array("USD", "EUR");
$bitpay_currency_list = array("USD", "EUR", "GBP", "AUD", "CAD", "CHF", "CNY", "RUB", "DKK", "HKD", "PLN", "SGD", "THB", "BTC");
$stripe_currency_list = array("USD", "CAD");
?>

Answer 1

删除数据库中的所有表并在同一数据库下重新填充它们。不再需要太担心客户记录，因为 Paypal 保存了我所有的交易记录。

;)