wordpress recover access details

Hi team,
I sometimes have trouble getting access details for Wordpress from new clients. Following along with articles from online (e.g. going into database and typing in a new password with MD5 hash) doesn't always work. Do you have any tips/suggestions on how I can do this?

I have just had a client hacked and tried resetting the password but it didn't work and my website host is unable to assist with the problem. In this instance, I am working on recovering from a backup, so all should be OK, but would like to improve my skills for the future.