Tuesday, 29 March 2016

Access denied; you need the SUPER privilege for this operation

Access denied; you need the SUPER privilege for this operation





ERROR 

This Stored Procedure  used to only on Localhost

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_delete_course`(In eid INT)
BEGIN
delete  from `courses` where courseid=eid;
END


REMOVE

DEFINER=`root`@`localhost`


Working Query 

This Stored Procedure  used to only on Server Side

CREATE  PROCEDURE `sp_delete_course`(In eid INT)
BEGIN
delete  from `courses` where courseid=eid;
END



Before Uploading to the Server 
 Clear DEFINER=`root`@`localhost` than working fine





0 comments:

Post a Comment