• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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

K
Resolved How to create a database user with a known password hash
Replies
6
Views
6K
Kaspar
K
Liwindo
Forwarded to devs WordPress Toolkit not able to clone instances with CiviCRM Plugin
Replies
1
Views
1K
IgorG
IgorG
A
Issue Problem with migration and not sufficient enough rights to use msyqldump command (I suppose)
Replies
10
Views
3K
Alan_SP
A
S
Issue Getting 404 Not Found NGINX error, not able to access plesk and website went down after update
Replies
2
Views
2K
Dave W
Dave W
M
Cloning Failed- Database error 1356 'view (null).(null) references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights
Replies
1
Views
3K
machump
M
Back
Top