1

I am getting an error while uploading my database to server. my database has many stored procedures(routines) I am getting the following error how i resolve that ?

SQL query: 

CREATE DEFINER=`root`@`localhost` PROCEDURE `getAttractions` ()  BEGIN

SELECT * FROM attractions ;

END$$

MySQL said:

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

RiggsFolly
  • 93,638
  • 21
  • 103
  • 149
Bilal Hussain
  • 149
  • 1
  • 12
  • it is clearly saying you , that you don't have a permission to do that , or you are on shared hosting or you are on localhost or anykind of server which doesn't allow you to process this oprations. – Arsh Singh Jul 14 '16 at 12:57
  • Then how i add a permission ? – Bilal Hussain Jul 14 '16 at 12:59
  • depends on what kind of host you are using, if it's shared hosting , then you can't use these queries inside console , you have to use their cpanel to make new users and set permissions. else if you are on localhost or vps or any personal server , then you must give permissions to the users you are trying to oprate with. – Arsh Singh Jul 14 '16 at 13:00
  • i am at shared hosting and i am trying to upload my database with procedures and i am getting the above mentioned error . I already set all the permissions after creating the user in cpanel mysql option – Bilal Hussain Jul 14 '16 at 13:03
  • seems like you are not allowed to do that on your shared hosting. they didn't gave you permission to do that. – Arsh Singh Jul 14 '16 at 13:06

0 Answers0