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