UPDATE smf_members SET passwd = SHA1(CONCAT(LOWER('your_admin_username'), 'your_new_password')) WHERE ID_MEMBER = 1 OR member_name = 'your_admin_username';