Unable to run SQL query: alter routine command denied to user for routine

Created:

2016-11-16 12:50:59 UTC

Modified:

2017-04-24 12:09:48 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to run SQL query: alter routine command denied to user for routine

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.5 for Windows

Symptoms

  1. Unable to execute the following query in phpMyAdmin:
    DELIMITER $$

    DROP FUNCTION IF EXISTS `Esempio` $$
    CREATE FUNCTION `Esempio` () RETURNS INT
    BEGIN
    RETURN 10;
    END $$

    DELIMITER ;

    DELIMITER $$

An error occurs:

#1370 - alter routine command denied to user 'databaseuser' for routine 'databasename'
  1. All permissions are granted for 'databaseuser' in:

Domains > example.com > Databases > User Management

Cause

This is Plesk internal issue with ID #PPPM-3592 ,which has been fixed in microupdate #27 .

Resolution

Apply the latest Plesk microupdates .

Have more questions? Submit a request
Please sign in to leave a comment.