All of a sudden, after the most recent Webmin update, my “backup virtual servers” has quit working. It’s always worked fantastically! and this is probably justa minor glitch, but I can’t seem to figure out what it is. When I try to backup all virtual servers to a local single file, I get this:
…
(bunch of successful stuff removed here)
…
… Dumping MySQL database s1nget_L0qbmnS5HFz …
… dump failed!
mysqldump: Got error: 1045: Access denied for user ‘root’@‘localhost’ (using password: YES) when trying to connect
Backup failed! See the progress output above for the reason why.
Good call on checking first if the password is working manually… Apparently it is not because when running “mysql -p” from command shell, I get:
mysql -p
Enter password: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
So it looks like it is NOT using my password in this case. I checked to see that root does in fact have a password set, and it is set to what it has always been so it’s still there. What do you think now?
Ah, you wouldn’t actually want to run that from the command shell, you would need to log in over SSH in order to run that.
The command shell is a good way to run non-interactive commands, but with “mysql -p”, it asks for input, which is something the command shell isn’t able to do.
I logged in locally instead of SSH, then used mysql -p to set the password to the same as it was before. Then went to Webmin -> Servers -> MySQL -> Module Config, and set the Administration password to also be the same… Still didn’t work. What to try next?