From c4b1caeb9532f64776e66c5a85fa69fa80c0dfdd Mon Sep 17 00:00:00 2001
From: quarters78 <quarters78@tuta.io>
Date: Sat, 30 Aug 2025 21:02:16 +0200
Subject: Core/Database: Fix database auto updater when using MySQL 9.4
 (#31243)

(cherry picked from commit 290a7b93107b4864f5aad57b415c9237922e3379)
---
 src/server/database/Updater/DBUpdater.cpp | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'src')

diff --git a/src/server/database/Updater/DBUpdater.cpp b/src/server/database/Updater/DBUpdater.cpp
index 462d345fcda..7de59cedd2e 100644
--- a/src/server/database/Updater/DBUpdater.cpp
+++ b/src/server/database/Updater/DBUpdater.cpp
@@ -407,6 +407,14 @@ void DBUpdater<T>::ApplyFile(DatabaseWorkerPool<T>& pool, std::string const& hos
     if (ssl == "ssl")
         args.emplace_back("--ssl-mode=REQUIRED");
 
+#if MYSQL_VERSION_ID >= 90400
+
+    // Since MySQL 9.4 command line client commands are disabled by default
+    // We need to enable them to use `SOURCE` command
+    args.emplace_back("--commands=ON");
+
+#endif
+
 #else
 
     if (ssl == "ssl")
-- 
cgit v1.2.3