When starting digikam, it complains that user has no CREATE TRIGGER privileges and doesnt connect to database (see attachment 1 [details]). Show grants for this user shows it has ALL priviledges on this database: MariaDB [(none)]> show grants for 'digikam'@'%'; +-----------------------------------------------------------------------------------------------------------------------+ | Grants for digikam@% | +-----------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'digikam'@'%' IDENTIFIED BY PASSWORD '*04E1D6' | | GRANT ALL PRIVILEGES ON `digikam`.* TO 'digikam'@'%' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `digikam_thumbs`.* TO 'digikam'@'%' WITH GRANT OPTION | +-----------------------------------------------------------------------------------------------------------------------+ 3 rows in set (0.01 sec) Reproducible: Always Steps to Reproduce: 1. Start digikam 2. 3. Actual Results: Refer to attachment 1 [details], no contents Expected Results: Show current libraries of fotos
Created attachment 94013 [details] Attachment 1 [details], error message Error message when starting up digikam.
Problem fixed, due to binary-logging of database, SUPER privilege was required. After adding SUPER privilege to user problem was gone.