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

[Bruno Friedmann]

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


Bruno Friedmann <brunofr at ioda.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |brunofr at ioda.net




--- Comment #1 from Bruno Friedmann <brunofr ioda net>  2011-01-08 21:22:32 ---
Reproductible always with 2.0dev

In fact after creating a user database, and giving him full rights ( GRANT ALL
on )
this instruction doesn't work in dbconfig


 702             <dbaction name="CheckPriv_CREATE_TRIGGER"><statement
mode="plain">
 703                 CREATE TRIGGER privcheck_trigger AFTER DELETE ON PrivCheck
 704                  FOR EACH ROW BEGIN
 705                 END;
 706             </statement>
 707             </dbaction>

mysql> CREATE TRIGGER privcheck_trigger AFTER DELETE ON PrivCheck
    -> FOR EACH ROW BEGIN
    -> END;
ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is
enabled (you *might* want to use the less safe log_bin_trust_function_creators
variable)
mysql>

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