• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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
3K
Kaspar
K
Liwindo
Forwarded to devs WordPress Toolkit not able to clone instances with CiviCRM Plugin
Replies
1
Views
784
IgorG
IgorG
A
Issue Problem with migration and not sufficient enough rights to use msyqldump command (I suppose)
Replies
10
Views
2K
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
854
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