[Digikam-devel] [Bug 280678] MYSQL : cannot migrate from sqlite database

[Daniel Berrange]

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

Daniel Berrange <dan-kde at berrange.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dan-kde at berrange.com

--- Comment #9 from Daniel Berrange <dan-kde at berrange.com> ---
FYI, I was hitting this exact same problem. Eventually I found that it is *not*
sufficient to just do "GRANT ALL PRIVILEGES" for the user/database in question.
I had to explicitly give the user the 'SUPER' privilege too. This is what I
eventually granted which allowed migration to work

mysql> show grants for 'digikam'@'%';
+--------------------------------------------------------------------------------------------------------+
| Grants for digikam@%                                                         
                         |
+--------------------------------------------------------------------------------------------------------+
| GRANT SUPER ON *.* TO 'digikam'@'%' IDENTIFIED BY PASSWORD '*XXXXX' | 
| GRANT ALL PRIVILEGES ON `digikam`.* TO 'digikam'@'%' WITH GRANT OPTION       
                         | 
| GRANT ALL PRIVILEGES ON `thumbnails-digikam`.* TO 'digikam'@'%' WITH GRANT
OPTION                      | 
+--------------------------------------------------------------------------------------------------------+

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