#1227 -拒绝访问；此操作需要(至少一种)超级特权

Question

你好，我现在和MySQL!有个问题

这里出什么问题了？我是一个cPanel用户，是的，我搜索了这个，没有找到明确的答案。这似乎比其他人有相同的错误代码问题更具体。请添加一个详细的答复，我可以跟随！我正在使用一个共享的主机帐户。

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$$

这里是错误代码：

MySQL said: Documentation

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

Answer 1

这意味着您没有使用root@localhost用户创建触发器的权限。

尝试从触发器命令中删除定义器：

创建root@localhost定义器= 函数fnc_calcWalkedDistance

Answer 2

只需删除"DEFINER=your user name@localhost“并从phpmyadminwill运行SQL即可。

Answer 3

如果要在cpanel上上载sql文件，请尝试在sql文件中使用cpanel用户名替换root用户。

在上述情况下，您可以编写

创建定义器= control_panel_username@localhost函数fnc_calcWalkedDistance

然后上传文件。希望它能帮上忙