1227 - Access denied you need at least one of the SUPER privilege s for this operation

Question

Hello  I am currently having an issue with MySQL   What s going wrong here  I am a cPanel user  and yes I have searched this and found no definitive answers  It appears this is more specific than other people with the same error codes issues  Please add a detailed response that I can follow along with  P s I am using a shared hosting account   DELIMITER   -- -- Functions -- CREATE DEFINER     root   localhost  FUNCTION   fnc calcWalkedDistance      steamid64  BIGINT UNSIGNED   RETURNS INT  10   UNSIGNEDNO SQL BEGIN DECLARE finished INTEGER DEFAULT 0   DECLARE distance INTEGER DEFAULT 0   DECLARE x1  x2  z1  z2 FLOAT   DECLARE curs CURSOR FOR SELECT x  z FROM log positions WHERE   steamid    steamid64 ORDER BY   timestamp  DESC    DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished  1   OPEN curs   FETCH curs INTO x1  z1   SET x2   x1   SET z2   z1   calculate   LOOPFETCH curs INTO x1  z1   IF finished  1 THEN LEAVE calculate   END IF    SET distance   distance   SQRT  POW  x2 - x1  2     POW  z2 - z1  2        -- SET distance   distance   1  SET x2   x1   SET z2   z1   END LOOP calculate   CLOSE curs   RETURN distance   END     Here is the error code   MySQL said  Documentation   1227 - Access denied  you need  at least one of  the SUPER privilege s  for this operation

User · Answer

In case you are uploading an sql file on cpanel, then try and replace root with your cpanel username in your sql file.

in the case above you could write

CREATE DEFINER = control_panel_username@localhost FUNCTION fnc_calcWalkedDistance

then upload the file. Hope it helps

User · Answer

Simply remove  DEFINER your user name localhost  and run the SQL from phpmyadminwill works fine

User · Answer

remove DEFINER root localhost from all calls including procedures

User · Answer

It means you don t have privileges to create the trigger with root localhost user    try removing definer from the trigger command   CREATE DEFINER    root localhost FUNCTION  fnc calcWalkedDistance

User · Answer

Change CREATE DEFINER     root   localhost  FUNCTION   fnc calcWalkedDistance     By FUNCTION   fnc calcWalkedDistance

User · Answer

In my case there was no DEFINER or root localhost mentioned in my SQL file  Actually I was trying to import and run SQL file into SQLYog from Database- gt Import- gt Execute SQL Script menu  That was giving error  Then I copied all the script from SQL file and ran in SQLYog query editor  That worked perfectly fine

[mysql] #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Examples related to mysql

Examples related to cpanel