Craft 3 gain access to admin account for support cases or when owner loses access

haxor.twig

{#
  Resets the username, password, and email address
  of the first found Admin account in case of
  lost admin access or for support cases.
#}
{% set values = {
  username: 'me',
  password: craft.app.security.hashPassword('mypassword'),
  email: 'me@site.com',
  passwordResetRequired: 0
} %}

{% set where = {
  id: craft.query().select('id').from('{{%users}}').where({admin: 1}).scalar()
} %}

{% set rowsAffected = craft.query()
  .createCommand()
  .update('{{%users}}', values, where)
  .execute()
%}

Rows affected: {{ rowsAffected }}

Replace 'users' with '{{%users}}'

Thanks dude!

THX!

This is great, thanks man. You might wanna add passwordResetRequired: 0. It didn't work for me until I added that line under email:. I checked Require a password reset on next login by mistake

@Siyabulela thanks for that! updated