[Digikam-devel] [Bug 262321] mysql user privileges

Felix Leif Keppmann felix.leif at keppmann.de
Mon May 16 19:21:44 BST 2011


Felix Leif Keppmann <felix.leif at keppmann.de> changed:

           What    |Removed                     |Added
                 CC|                            |felix.leif at keppmann.de

--- Comment #6 from Felix Leif Keppmann <felix leif keppmann de>  2011-05-16 20:21:42 ---
Same issue... but appears not only in digiKam context. You can find a lot of
threads about it. I also found:

"The TRIGGER privilege enables trigger operations. You must have this privilege
for a table to create, drop, or execute triggers for that table. This privilege
was added in MySQL 5.1.6. (Prior to MySQL 5.1.6, trigger operations required
the SUPER privilege.)" (
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_trigger ).

Ok, current stable in the 5.1 branch is 5.1.57 and 5.1.6 never got stable

Somebody on MySQL 5.5.x should check if a database level privilege "TRIGGER" is
available because it would probably fix this issue.

Is somebody with this issue not on MySQL 5.1.x?

Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the Digikam-devel mailing list