[digiKam-users] digikam mariadb configuration fail

[Maik Qualmann]

You executed these commands (with customization) as the mysql root user?

mysql -u root -p

CREATE USER 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'USERNAME'@'HOSTNAME' IDENTIFIED BY 'password';
CREATE DATABASE digikam;
GRANT ALL PRIVILEGES ON digikam.* TO 'USERNAME'@'HOSTNAME';
FLUSH PRIVILEGES;

Am Samstag, 9. Februar 2019, 21:57:38 CET schrieb leoutation at gmx.fr:
> Hi
> Today, I installed  digikam on another computer. Sqlite works but not
> Mariadb.
> Mariadb database/permissions/user  is ok, connection works normally from
> digikam.
> I could not create schema with db migration from sqlite to mysql or/and
> with "mysql server" configuration, it doesn't work.
> I got message "the database is not valid. The "DBVersion" setting
> doesn't exist. The current database schema version cannot be verified.
> Try to start with an empty database"
> Other strange point, I configured "local collection" on HD but then, it
> is considered as "removable media".
> digikam-git r41540