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
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
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
If the migration takes this long, something is wrong with your configuration. Maik
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