All those password problems :o)

I ehhh forget my admin password of 1 of my XOOPS sites ... so I decided to go into the MySQL database to clear the password of the admin user and thought I could login with a blank password. And .. that doesn't work.

What do I have to do? Is a blank password MD5 encrypted as well?!

update: oh btw ... I'm not able to create a new user and make an admin of it with phpmyadmin, because the site is turned off.

generated blank md5 password with <?php echo md5(""); ?> doesn't work either :'(

Why don't you just *copy* the password from one of your other sites?