mysqldump: Got error: 1045: Access denied for user when backing up a Database

3 posts / 0 new
Last post
#1 Mon, 07/19/2010 - 10:38
jtelo

mysqldump: Got error: 1045: Access denied for user when backing up a Database

Hi Everyone,

Im having problems when i try to do a database backup (Full backup when incluide a database) from Virtualmin/Webmin.

This is the error:

Database backup failed : mysqldump failed :

mysqldump: Got error: 1045: Access denied for user 'desarrollo'@'localhost' (using password: YES) when trying to connect

i don't know why but the Virtualmin/Webmin try to do a backup with the user "desarrollo" instead of the root user.

Where i can change this settings to fix the problem?

Thanks

Mon, 07/19/2010 - 21:37
andreychek

Well, I imagine that's a security measure... only accessing databases as the user in question.

In this case, it sounds like there may be an issue with the database password for that particular user.

You may want to go into Edit Databases for that particular domain, and reset the password in there so that Virtualmin has the correct one on file.

-Eric

Tue, 07/20/2010 - 11:34
jtelo

Hi Eric,

First of all thanks for the quick reply.

I don't know why but the Virtualmin always use the user 'desarrollo' when i try to backup whatever MySQL databases.

That user is a Developer user.

I have another Virtualmin server configured in the same way, with the same hardware, and i don't have that problem.

Where Virtualmin/Webmin store the Use/Password will use when try to backup a MySQL database?

Thanks

Topic locked