Is there any reason why you could not use phpMyAdmin now? Wordpress have nice info on how you can reset admin password: https://codex.wordpress.org/Resetting_Your_Password, you just need to pick what solution you want to apply.
Thanks this does not help
I am locked out of my account and need to reset.
With cpanel all I had to do was to use php admin
I need to be able to reset my Wordpress password via virtualmin or Wordpress db.
I do not have access to my Wordpress dashboard and forget password is not working
The person I paid to install move my site from cpanel to virtualmin did not use it.
Anyway thanks for the information. I was reluctant to use the emergency php script but that did the trick.
I really prefer working directly in the db as I can see what I am doing.