Lost password, and edit it in database, cant login now.

Hi

I was having problems logging into my wordpress site, so decided to edit the user password in the database, here User_URL and User_activation_key was empty, and I wasn’t able to save/update the user, without adding a Zero, because the 2 fields was not a NULL type.

When looking at the user_pass field I cant find the type MD5 for the field.

After saving I still can’t login, and I know it the right password…