installation error

(2 posts) (2 voices)

Tags:

No tags yet.

  1. manishmalviya, Member

    how to resolve this error?

    Checking if myDBR reporting objects exist ToDo
    Your MySQL server does not allow creation of stored functions. To allow creation of functions issue the following statement

    mysql> SET GLOBAL log_bin_trust_function_creators = 1;

    Click Retry Create Objects once you have allowed creation of functions.
    Click Ignore to use myDBR without functions. This means that mydbr_style() will not be avaible in stored procedures, but otherwise myDBR will function normally.

    MySQL error 1419: 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)

    "where to execute below given command ?
    "mysql> SET GLOBAL log_bin_trust_function_creators = 1;"

    if i execute this on mysql query window error occurs
    Error
    SQL query:

    SET GLOBAL log_bin_trust_function_creators =1

    MySQL said:

    #1227 - Access denied; you need the SUPER privilege for this operation

  2. myDBR Team, Key Master

    You may want to re-run the command as a root-user.

    SUPER privilege in MySQL allows, among other things, change database server settings. log_bin_trust_function_creators is one of these settings that do require SUPER privilege.

    --
    myDBR Team


Reply

You must log in to post.