Was ein Theater! Tatsächlich hat mir das hier weitergeholfen.
How to Reset a XenForo Password from phpMyAdmin
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.
xfpoint.com