Hi,
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: "XXX" localhost
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?
Server:
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.
Did in the time between mysql / mariadb version updates.?
https://stackoverflow.com/questions/47893094/mariadb-host-works-on-local...
https://stackoverflow.com/questions/47242111/mysql-able-to-connect-to-lo...
Wow. I swore I had mariaDB installed (the machine was originally a Ubuntu 14 LTS), but now I see that it's mysql:
Your MySQL connection id is 4909Server version: 5.7.27-0ubuntu0.16.04.1 (Ubuntu)
(I did not notice this happening)
I notice in netstat that it's listening on 127.0.0.1.
I also notice that
skip_name_resolveis OFFWould the best course be to change the DB entries for mysql.user to use 127.0.0.1? (I notice all the users there use
localhostand not just this problematic one)Edit: PS, I used the virtualmin setting to use hashed passwords everywhere, so my passwords in this table are, of course, hashed.
Hi,
I tried playing around with settings, by editing
/etc/mysql/conf.d/mysql.cnfand settingskip_name_resolve=ONand restarting the service, but still can't change the password... (same error as above). Suggestions?When disabling the site again (because it wasn't working anyway):
MySQL database failed! : mysql::execute_sql_logged failed : SQL set password for 'XXX'@'127.0.0.1' = '00000000000000000000000000000000000000000' failed : Can't find any matching row in the user table at /usr/share/webmin/web-lib-funcs.pl line 1477.Ideas on a fix? Why has this suddenly broken? Any help appreciated!