Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Access denied; you need the SUPER privilege for this operation

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

  1. rajeshatbuzz

    rajeshatbuzz Member

    Joined:
    Sep 19, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    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:
    173
    Likes Received:
    2
    Trophy Points:
    68
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Looking at the error message, you need to import it as root from WHM >> phpmyadmin.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. rajeshatbuzz

    rajeshatbuzz Member

    Joined:
    Sep 19, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    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:
    51
    #4 rajeshatbuzz, Jul 9, 2012
    Last edited: Jul 9, 2012
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. rajeshatbuzz

    rajeshatbuzz Member

    Joined:
    Sep 19, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    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,609
    Likes Received:
    32
    Trophy Points:
    238
    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).
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice