If you have lost access to email, there are many ways to reset the password using phpMyAdmin. Here are a couple of really simple ways to reset it.
Forgot your XenForo password? Don’t worry. This step by step guide will show you how to recover a lost password in XenForo. Works for admins and members.