[digiKam-users] DB migration error: "Error while creating the database schema."

[Tomer Altman]

To the digikam community:

I hope that this finds you well. I am a new digikam user and have been
very happy using it to merge several large sets of photos & videos into
a single collection. Until now I have used the SQLite DB back-end, but
my intention has been to move on to using the external MySQL server DB
back-end to allow me to edit the collection from multiple machines.

I am using Digikam v.7.1.0
(commits.kde.org/digikam/d52927ebc98ee24c9fc3a3a34f527d4d21b09fb3) on
Mac OS X v10.13.6. I have been using the following documentation to
guide me:

https://docs.kde.org/trunk5/en/extragear-graphics/digikam/using-setup.html

I installed MySQL v8.0, and executed the following SQL commands to set
up the database (see below). Note that I had to go beyond the
documentation and add the "WITH mysql_native_password" clause in order
for MySQL to use a password plugin that is supported by Digikam (at
least the Mac version).

When using the DB migration tool, I am able to connect to the MySQL
server, but when I try to initiate the migration, I get a pop up window
saying "Error while creating the database schema".

I'm not sure what the error is. I do see on the server side that the
digikam_core database does get populated with tables. The digikam
database does not.

I have some DBA experience, so I'm sure that I could work past any
mis-configuration issues on the MySQL side, if only I could see a more
detailed error message. Any suggestions on how to get past this
uninformative error message would be greatly appreciated. Thanks!

Cheers,

~Tomer

---

CREATE USER 'digikam'@'%' IDENTIFIED WITH mysql_native_password BY
<password>;

GRANT ALL ON *.* to 'digikam'@'%';

CREATE DATABASE digikam;

GRANT ALL PRIVILEGES ON digikam.* TO 'digikam'@'%';

CREATE DATABASE digikam_core;

GRANT ALL PRIVILEGES ON digikam_core.* TO 'digikam'@'%';

FLUSH PRIVILEGES;


-- 
Please do not send me sensitive information (e.g., passwords, personal details, financial/health information) via email, as it is not secure.
Please contact me to determine the best way to transfer sensitive information safely. Thank you!