How to change Bitrix password through myadmin?

Question

1C-Bitrix

Got a site on Bitrix. There is FTP and DB.
Tell me how to change the password? I get into the database, field, standard, write
b_user

UPDATE `b_user` SET password = MD5('passwd') where login = "admin";

Doesn't plow. I generate MD5 and I interpose into a DB - does not plow.
I changed the admin mail to my own, the letter with the keyword does not come.
what am i doing wrong?

Answer 1

If you have access via FTP, then create a badass_login.php script in the root of the site with the following content:

<?php
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_before.php");
$USER->Authorize(1);
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/epilog_after.php");
?>

Run the script by following the link site.com/badass_login.php
That's it. You are now logged in as an admin.
Go to the site.com/bitrix admin panel and there, in user management, you can easily change the password to a new one.
After all the manipulations, delete the created authorization script.

Answer 2

If you have access to ftp, then just run the code

$user = new CUser;
$fields = Array(
  "PASSWORD"          => "123456",
  "CONFIRM_PASSWORD"  => "123456",
  );
$user->Update($ID, $fields);
$strError .= $user->LAST_ERROR;

Answer 3

It's not just md5, there's also salt added

$salt = randString(8);
$arFields["PASSWORD"] = $salt.md5($salt.$arFields["PASSWORD"]);

bxapi.ru/src/?module_id=main&name=CUser::Add
It is enough to write 'aaaaaaaa'.md5('aaaaaaaa'.'password') into the database.

Answer 4

go to the database, find the field with the user, change the email to your own, then use the password recovery function

Answer 5

If user registration is enabled, try creating a user through the standard registration mechanism on the site, and then in myadmin copy the system-converted password of this user and replace the administrator password with it.

Answer 6

login may not be admin.
Vryatli will succeed through the base.
so the most working option was proposed by Alexey Emelyanov