Access denied for user 'debian-sys-maint' in Virtual Server backup

Virtualmin
1

Hi all,

when doing a scheduled Virtual Server backup I get the following error for every MySQL database:

Dumping MySQL database foo .. .. dump failed! mysqldump: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect

System is a standard Debian 5.0. The MySQL login using credentials from /etc/mysql/debian.cnf is working fine at the Shell. Also using user root and the password as seen in Webmin > Servers > MySQL Database Server > Change Administration Password is working.

Any hints where to get more information/solution for this error?

regards,
Bernhard

2

Cause was a symbolic link .my.cnf -> /etc/mysql/debian.cnf inside /root which I created to get easy access to MySQL databases. Once I removed it the backup run without error.