title: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
body: <p><strong>Hello, I am currently having an issue with MySQL!</strong></p>
  
  <p>What's going wrong here? I am a <em>cPanel</em> 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.</p>
  
  <pre><code>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$$
  </code></pre>
  
  <p><strong>Here is the error code:</strong></p>
  
  <pre><code>MySQL said: Documentation
  
  #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
  </code></pre>