From aa0cbbb7f33e8edebfa2ea152099fed10c6fad6f Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 31 八月 2026 16:50:11 +0800
Subject: [PATCH] fix(database): 解决本地数据库备份认证问题

---
 yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/service/database/DatabaseBackupServiceImpl.java |    5 +++++
 1 files changed, 5 insertions(+), 0 deletions(-)

diff --git a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/service/database/DatabaseBackupServiceImpl.java b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/service/database/DatabaseBackupServiceImpl.java
index b78f3d1..d033692 100644
--- a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/service/database/DatabaseBackupServiceImpl.java
+++ b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/service/database/DatabaseBackupServiceImpl.java
@@ -97,6 +97,11 @@
             log.warn("鏃犳硶浠庨厤缃垨 JDBC URL 瑙f瀽瀹屾暣鐨勬暟鎹簱淇℃伅: host={}, port={}, db={}", dbHost, dbPort, dbName);
             throw new ServiceException(500, "鏃犳硶瑙f瀽鏁版嵁搴撳浠借繛鎺ヤ俊鎭紝璇峰湪 yudao.database-backup 涓厤缃� host/port/database");
         }
+        // localhost 缁熶竴璧� TCP 127.0.0.1锛歮ysqldump 瀵� localhost 鍙兘璧� socket/loopback锛�
+        // 鑰屽鍣ㄥ唴 root@localhost 璁よ瘉瑕佹眰涓� TCP root@'%' 涓嶅悓锛屽己鍒� TCP 閬垮厤璁よ瘉澶辫触
+        if ("localhost".equalsIgnoreCase(dbHost)) {
+            dbHost = "127.0.0.1";
+        }
         String username = StrUtil.isEmpty(backupUsername) ? dbUsername : backupUsername;
         String password = StrUtil.isEmpty(backupPassword) ? dbPassword : backupPassword;
 

--
Gitblit v1.9.3