1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Access denied; you need the SUPER privilege for this operation

Discussion in 'Database Discussions' started by rajeshatbuzz, Jul 9, 2012.

  1. rajeshatbuzz

    rajeshatbuzz New Member

    Joined:
    Sep 19, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I am using mysql 5.1 and user has all the privilege including triggers. but when i import one db files.. I am getting following error...

    Any help on this?

    Code:
    SQL query:  
    DELIMITER ; ;
    
    /*!50003 CREATE*//*!50017 DEFINER=`surgnet_snetus`@`localhost`*//*!50003 TRIGGER `inserttree` AFTER INSERT ON `account_owner` FOR EACH ROW BEGIN DECLARE s INTEGER; DECLARE t INTEGER; DECLARE ParentPath varchar(30); SET s=NEW.REPORTS_TO; SET t = NEW.ID; if s is NULL then insert into hierarchy_path values (t,t); else select PATH INTO ParentPath from hierarchy_path where ID = s; insert into hierarchy_path values (t,CONCAT(ParentPath,',',t)); end if; END */ ; ;
    MySQL said:  
    #1227 - Access denied; you need the SUPER privilege for this operation
    
     
  2. milesgeek

    milesgeek Member

    Joined:
    May 23, 2012
    Messages:
    159
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    India
    Looking at the error message, you need to import it as root from WHM >> phpmyadmin.
     
  3. rajeshatbuzz

    rajeshatbuzz New Member

    Joined:
    Sep 19, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Just wondering having user all the access provided including trigger, why it is needed by root user?
     
  4. rajeshatbuzz

    rajeshatbuzz New Member

    Joined:
    Sep 19, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    #4 rajeshatbuzz, Jul 9, 2012
    Last edited: Jul 9, 2012
  5. cPanelTristan

    cPanelTristan Active Member
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,621
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
  6. rajeshatbuzz

    rajeshatbuzz New Member

    Joined:
    Sep 19, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Yes. I did read this post. Could you please tell me following..

    1. How to check if bin logs has been enabled or not?
    2. Any suggestion on format of request?
     
  7. cPanelTristan

    cPanelTristan Active Member
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,621
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    For the bin logs, could you simply paste your /etc/my.cnf file?

    As for the request, please provide the exact command being used in PHPMyAdmin, the root login credentials and the cPanel account login credentials (since we'll have to log into that cPanel account to run the command).
     

Share This Page