Tuesday, 27 August 2013

SUPER privilege(s) for this operation

SUPER privilege(s) for this operation

I create my database and user navid in my shared server with cpanel
(databases -> mySQL@ Databases -> add new user),and then selected ALL
PRIVILEGES for user navid. I was importing mydatabase.sql when I was
confronted with this error. how do i fix the error?
Error
SQL query:
DELIMITER $$--
-- Procedures
--
CREATE DEFINER = `navid`@`%` PROCEDURE `d_answer` ( OUT `sp_out` INT( 11 )
, IN `sp_id` INT( 11 ) ) NO SQL BEGIN DELETE FROM `tblname` WHERE `a_id` =
sp_id;
SET sp_out = ROW_COUNT( ) ;
END$$
MySQL said: Documentation
#1227 - Access denied; you need (at least one of) the SUPER privilege(s)
for this operation

No comments:

Post a Comment