• The APS Catalog has been deprecated and removed from all Plesk Obsidian versions.
    Applications already installed from the APS Catalog will continue working. However, Plesk will no longer provide support for APS applications.
  • Please be aware: with the Plesk Obsidian 18.0.78 release, the support for the ngx_pagespeed.so module will be deprecated and removed from the sw-nginx package.

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
3K
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