I have recently set up a Virtualmin system with a remote MySQL server. I have configured Virtualmin to use the remote MySQL server. Creating domains, creating and removing databases, backing up, etc. all works well when I'm logged in as a user to Virtualmin. However, if I try to restore a backup as a user (rather than as a root user), then I get the following output from the Web UI during the restore:
Starting restore of 1 domains from local file /home/test/virtualmin-backup/test.camna.com_20160318_1008 .. Extracting backup archive files .. .. done Restoring backup for virtual server test.camna.com .. Extracting TAR file of home directory .. .. done Setting ownership of home directory .. .. done Restoring allowed MySQL hosts .. .. done Deleting old MySQL databases .. .. done Re-loading MySQL database dbtest .. Creating MySQL database dbtest .. .. done .. load failed! ERROR 1045 (28000): Access denied for user 'test'@'192.168.217.82' (using password: YES) .. failed! See the progress output above for the reason why.
I can do a restore from the command line as the user just fine and everything else continue to works fine. Does the permissions change at all during a restore? If so, could it be that it's trying to do the restore before it gives the user permissions from this host? Just a theory I wanted to mention, but I don't know that it's the problem.