[Digikam-devel] [digikam] [Bug 351245] New: Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs

[Gerard Dirkse]

https://bugs.kde.org/show_bug.cgi?id=351245

            Bug ID: 351245
           Summary: Unable to connect to mysql database, due to missing
                    'create trigger' while user has ALL privileges on
                    digikam DBs
           Product: digikam
           Version: 4.12.0
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: grave
          Priority: NOR
         Component: Database
          Assignee: digikam-devel at kde.org
          Reporter: gerard.dirkse at kpnmail.nl

When starting digikam, it complains that user has no CREATE TRIGGER privileges
and doesnt connect to database (see attachment 1). 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, no contents

Expected Results:  
Show current libraries of fotos

-- 
You are receiving this mail because:
You are the assignee for the bug.