Admin backup error: mysqldump uses wrong user.

[TrafalgarLaw999]

I use the "Admin Backup" function on the web interface. The job was executed and returned error, and all the process rolled back. Zip files seem to be deleted after the error. This is the error message sent to me in the message system. Shouldn't the DA use root user?

Error while backing up database domain2_db1
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'domain1_db'@'localhost' to database 'domain2_db1' when selecting the database

Error while backing up database domain2_db2
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'domain1_db'@'localhost' to database 'domain2_db2' when selecting the database

Error while backing up database domain2_db3
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'domain1_db'@'localhost' to database 'domain2_db3' when selecting the database

Error while backing up database domain2_db4
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'domain1_db'@'localhost' to database 'domain2_db4' when selecting the database

Error while backing up database domain2_db5
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'domain1_db'@'localhost' to database 'domain2_db5' when selecting the database

Error while backing up database domain2_db6
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'domain1_db'@'localhost' to database 'domain2_db6' when selecting the database


<23:35:06>
cannot find file: #!/bin/sh
<23:35:06>
Error while backing up database domain3_db
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'domain1_db'@'localhost' to database 'domain3_db' when selecting the database


<23:42:49>
cannot find file: #!/bin/sh
<23:42:49>

OS: CentOS 6.0 64-Bit
DA: 1.51.3

Thanks!

 

[zEitEr]

Hello,

Directadmin does not use root to connect to MySQL.

Directadmin uses users credentials do dump/restore tables, otherwise there would be a security flaw. Users can download their backups, modify and upload it back.