php - 备份问题 DirectAdmin - Centos 7

Question

我希望有人能帮我解决这个问题。在 Centos 7 + DirectAdmin 中，当我想以管理员身份对所有用户进行备份时遇到问题。

我用谷歌搜索了很多东西，但没有任何帮助......我希望有人能帮我解决这个问题我准备为此付费。

错误信息:

Error while backing up database admin_USER1
Error while backing up database admin_USER1: The sql file is 0 bytes in size: /home/admin/admin_backups/admin/backup/admin_USER1.sql
mysqldump error output: mysqldump: Got error: 1045: "Access denied for user 'da_admin'@'localhost' (using password: YES)" when trying to connect


<18:34:04>
Error while backing up database RES_USER2
Error while backing up database RES_USER2: The sql file is 0 bytes in size: /home/admin/admin_backups/ken/backup/RES_USER2.sql
mysqldump error output: mysqldump: Got error: 1045: "Access denied for user 'da_admin'@'localhost' (using password: YES)" when trying to connect

Error while backing up database RES_USER3
Error while backing up database RES_USER3: The sql file is 0 bytes in size: /home/admin/admin_backups/ken/backup/RES_USER3.sql
mysqldump error output: mysqldump: Got error: 1045: "Access denied for user 'da_admin'@'localhost' (using password: YES)" when trying to connect

Answer 1

你好，

您的 da_admin mysql 密码有问题。您的 da_admin 用户无法连接 mysql 服务器，因此您遇到了这个问题。您需要重置您的 da_admin mysql 密码。您可以在/usr/local/directadmin/conf/mysql.conf 文件中找到当前密码。请检查当前密码并尝试重置密码，这样您的备份就不会出现任何问题。您可以通过以下步骤重置 da_admin mysql 密码

http://help.directadmin.com/item.php?id=45