The Community Forums

Interact with an entire community of cPanel & WHM users!
  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 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. MilesWeb

    MilesWeb Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2012
    Messages:
    174
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Looking at the error message, you need to import it as root from WHM >> phpmyadmin.
     
  3. rajeshatbuzz

    rajeshatbuzz 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 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 Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    19
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
  6. rajeshatbuzz

    rajeshatbuzz 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 Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    19
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    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).
     
Loading...

Share This Page