How to reset admin user in Bugzilla

I lost the admin password for bugzilla, but i had a test user with no admin privileges.
Following query enabled me to set the test user into admin. Run these queries in bugzilla’s mysql DB.

1. SELECT @myusr := userid FROM profiles WHERE login_name=”your email here”;
2. SELECT @admin := id FROM groups WHERE name=”admin”;
3. INSERT INTO user_group_map (user_id,group_id,isbless,grant_type) VALUES
(@myusr,@admin,0,0);