• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:
    https://survey.webpros.com/
  • On Plesk for Linux mod_status is disabled on upgrades to improve Apache security.
    This is a one-time operation that occurs during an upgrade. You can manually enable mod_status later if needed.

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
880
MHC_1
M
M
Issue How to repair "plesk repair db"
Replies
4
Views
1K
scsa20
scsa20
K
Resolved How to create a database user with a known password hash
Replies
6
Views
9K
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
4K
Alan_SP
A
Back
Top