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