• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

Issue PhpMyAdmin Access Issue To Create Functions

U

umaira.itack

New Pleskian
Dear Support,

need Enable privileges to create functions in routine for particular MySQL database. How would it be possible?
but I have access to create stored procedures.

Not able to execute the following script.
SET GLOBAL log_bin_trust_function_creators = 1
Click to expand...

MySQL said: Documentation
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
-----------------

Could you tell me, how can I fix this problem?
 

Attachments

  • db_rights.png
    db_rights.png
    27.4 KB · Views: 6
  • func_error.png
    func_error.png
    86.6 KB · Views: 6
You must log in or register to reply here.

Similar threads

M
Resolved Tips for resolving failure to dump SQL for Plesk Backup ("Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = ..." )
Replies
6
Views
2K
MHC_1
M
M
Issue How to repair "plesk repair db"
Replies
4
Views
2K
scsa20
scsa20
K
Resolved How to create a database user with a known password hash
Replies
6
Views
10K
Kaspar
K
Liwindo
Forwarded to devs WordPress Toolkit not able to clone instances with CiviCRM Plugin
Replies
1
Views
2K
IgorG
IgorG
A
Issue Problem with migration and not sufficient enough rights to use msyqldump command (I suppose)
Replies
10
Views
5K
Alan_SP
A
Back
Top