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

Question

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

Answer 1

To understand your doubt better, I assume this would mean 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

This should help solve your problem.

If you need to learn more, it's recommended you join the best Web Development courses online today.

Thanks!