I had a website that had been disabled for quite some time (a month or two) and recently re-enabled it, but got an error stating that the DB user's password failed to be reset. Unfortunately, I didn't take note of the exact error message I received. Trying to set the password (to what it should be) manually, I get this error:
Failed to change database passwords : SQL set password for 'XXX'@'127.0.0.1' = password('PASS') failed : Can't find any matching row in the user table
Looking around for solutions (on virtualmin), I notice that there was a request for
select user,host from mysql.user where user = "XXX" which returns for me:
So, it seems that my problem is that my virtmin is using 'localhost' as the host when it was set up, but the current version of virtmin (6.08.gpl) is trying to use 127.0.0.1....
I've disabled and restored this site a few times in the past without any issues, so figure it's to do with a recent virtmin update (it's a staging website that I take offline when not needed)
What's the best way to restore the password, so that the site works?
Operating system Ubuntu Linux 16.04.1
Virtualmin version 6.08.gpl Pro
Webmin version 1.932
Package updates: All Virtualmin packages are up to date.