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

[Felix Leif Keppmann]

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


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
status? 

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.