517251 2026-03-07 18:36:36 +0000 MariaSQL Migration 2026-03-07 21:31:37 +0000 1 1 2 Applications digikam Database-Migration 9.0.0 Microsoft Windows Microsoft Windows RESOLVED INVALID NOR wishlist --- 0 zunar digikam-bugs-null metzpinguin 9.1.0 0 oldest_to_newest 2501466 0 zunar 2026-03-07 18:36:36 +0000 Hi! I've been experimenting a bit. I wanted to set up a MariaDB database on my Synology NAS again (without Docker). DigiKam's migration process includes an SQL example under "Prerequisites" showing how to create the user and database in phpMyAdmin. The hostname of the SQL server is simply copied from the previous tab. CREATE USER 'digikam'@'synology' IDENTIFIED BY 'password'; GRANT ALL ON *.* TO 'digikam'@'synology' IDENTIFIED BY 'password'; CREATE DATABASE `digikam`; GRANT ALL PRIVILEGES ON `digikam`.* TO 'digikam'@'synology'; FLUSH PRIVILEGES; Unfortunately, this doesn't work in my case, as it only allows local access to the database from the Synology NAS. To allow external connections, a % symbol needs to be used. Here's the SQL command that appears when I create it manually. CREATE USER 'digikam'@'%' IDENTIFIED BY 'password';GRANT ALL PRIVILEGES ON *.* TO 'digikam'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `digikam`;GRANT ALL PRIVILEGES ON `digikam`.* TO 'digikam'@'%'; Should this be noted in the description in the migration window? Andy 2501498 1 metzpinguin 2026-03-07 20:35:52 +0000 Not really, it's just a suggestion; there are many ways to access a MySQL server. The % sign is a wildcard for any connection. And it shouldn't be used for security reasons, though it might be okay for a home user. You could also use the IP address. Only use MySQL if you plan to use digiKam on multiple computers. SQLite on an SSD is faster, fully supports UTF-8, etc., and is easier for the user to manage. A NAS is not often a good MySQL server because it performs resource management and allocates limited storage and performance to services. Maik 2501499 2 zunar 2026-03-07 20:50:18 +0000 I also tried using the IP address. That didn't work either. I only managed to access the database successfully using %. I'm aware of the speed reduction. The local SQLite database is really very fast. The migration is also very slow. I hope it will be finished by tomorrow morning. 96,000 files Andy 2501502 3 metzpinguin 2026-03-07 21:10:51 +0000 If the migration takes this long, something is wrong with your configuration. Maik 2501507 4 zunar 2026-03-07 21:31:37 +0000 Everything's fine :-) I've already tried so many settings to speed up the MySQL server. I haven't found any good settings from other users online yet. Maybe I'll still find the perfect combination. Oh look! The % symbol for the remote MySQL server is also mentioned in the "docs.digikam.org". Andy