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

[schultzter]

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

schultzter <eric at schultzter.ca> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |eric at schultzter.ca

--- Comment #14 from schultzter <eric at schultzter.ca> ---
I just wanted to confirm I'm having the same issue, but digikam is running on a
64-bit slackware system and MySQL 5.0 is running a ReadyNAS Duo (sparc version
of Debian). Grant SUPER to my digikam user didn't work!!!

This is the output of my SHOW GRANTS:

mysql> show grants for 'digikam';
+--------------------------------------------------------------------------------------------------------+
| Grants for digikam@%                                                         
                         |
+--------------------------------------------------------------------------------------------------------+
| GRANT SUPER ON *.* TO 'digikam'@'%' IDENTIFIED BY PASSWORD '*xxx' |
| GRANT ALL PRIVILEGES ON `digikamthumbs`.* TO 'digikam'@'%' WITH GRANT OPTION 
                         |
| GRANT ALL PRIVILEGES ON `digikam`.* TO 'digikam'@'%' WITH GRANT OPTION       
                         |
+--------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

and this is the output of my STATUS:
mysql> STATUS;
--------------
mysql  Ver 14.14 Distrib 5.1.56, for slackware-linux-gnu (x86_64) using
readline 5.1

Connection id:          37
Current database:       digikam
Current user:           digikam at workstation1
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.24a-Debian_3.infrant1 Infrant ReadyNAS distribution
Protocol version:       10
Connection:             nas1 via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 2 days 2 min 1 sec

Threads: 1  Questions: 1092  Slow queries: 0  Opens: 416  Flush tables: 1  Open
tables: 26  Queries per second avg: 0.006
--------------

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