Question: Change Admin Password

Change Admin Password

How do I change the admin password through PHPmyadmin?

SP

Sach P

Asked

How do I change the admin password through PHPmyadmin?

  • SP

    Sach P

    Answered

    I tried with this but it doesnt login with username, bbadmin and password: @!123

    INSERT INTO tec_users (last_ip_address, ip_address, username, password, salt, email, activation_code, forgotten_password_code, forgotten_password_time, remember_code, created_on, last_login, active, first_name, last_name, dob, phone, avatar, gender, group_id, wp_login_token, last_activity, subscription, digest_date, avatar_url, accept_messages, banned_at, banned_by, message, unban_date, signature) VALUES (0x39362e3234382e3132352e313136, 0x7f0000, ‘bbadmin’, SHA2(‘@!123’, 256), NULL, ‘[email protected]’, NULL, ‘9ed3e13131963a6b5ab0875fceb8e86bbfb50d39’, 1687864150, ‘940a20408b0235261e42fba374445c1937f0f224’, 1351661704, 1687283995, 1, ‘Admin’, ‘User’, ‘1982-09-12’, ‘012345678’, NULL, ‘male’, 1, NULL, ‘1687284789’, 2, ‘2023-06-20’, NULL, 0, NULL, NULL, NULL, NULL, NULL);

  • MS

    Mian Saleem

    Answered

    Hello,

    You can update password column to e9599f4555077e51455f5d8b5af1eec9cbdadd14 to set it to default 12345678

    Thank you

  • Login to Reply