[digiKam-users] digikam mariadb configuration fail

[leoutation at gmx.fr]

On 2/10/19 8:56 AM, Maik Qualmann wrote:
> 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;

Yes and beside, when i test db connection, digikam says it is ok

> 
> 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
> 
> 
> 
> 


-- 
Maderios