[Digikam-devel] [Bug 262321] MYSQL : user privileges management

[davidebasilio]

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





--- Comment #18 from davidebasilio <marsicanbear gmail com>  2012-02-21 09:37:29 ---
I finally achieved to work around this issue by starting mysql (version 5.1.61)
with the --log-bin-trust-function-creators=1 option.
As far as I understood, this makes the server trust unprivileged users with the
TRIGGER privilege and lets them actually create triggers, without the need of
the SUPER privilege.
More details here: 

http://stackoverflow.com/questions/1627383/cant-create-mysql-trigger-with-trigger-privilege-on-5-1-32
http://dev.mysql.com/doc/refman/5.1/en/stored-programs-logging.html

Hope it helps someone.

davide

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