Results 1 to 7 of 7

Thread: Access denied; you need the SUPER privilege for this operation

  1. #1
    Registered Member
    Join Date
    Sep 2009
    Posts
    5

    Question Access denied; you need the SUPER privilege for this operation

    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. #2
    Registered Member
    Join Date
    May 2012
    Location
    India
    Posts
    121
    cPanel Access Level

    Root Administrator

    Default Re: Access denied; you need the SUPER privilege for this operation

    Looking at the error message, you need to import it as root from WHM >> phpmyadmin.

  3. #3
    Registered Member
    Join Date
    Sep 2009
    Posts
    5

    Default Re: Access denied; you need the SUPER privilege for this operation

    Just wondering having user all the access provided including trigger, why it is needed by root user?

  4. #4
    Registered Member
    Join Date
    Sep 2009
    Posts
    5

    Default Re: Access denied; you need the SUPER privilege for this operation

    Hi,

    I am using mysql5.1 + WHM 11.32.3 (build 21). but sill I am getting same error as above. Can you plz help me out. I am using phpmyadmin to create procedures/triggers.
    Referring following thread could not find any help...
    http://forums.cpanel.net/f334/mysql-...4-a-73842.html
    Last edited by rajeshatbuzz; 07-09-2012 at 01:55 PM.

  5. #5
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel Access Level

    Root Administrator

    Default Re: Access denied; you need the SUPER privilege for this operation

    Hello,

    So, just to ensure this isn't the issue, you don't have binary logging enabled, right? Per this post, this would cause triggers to not function:

    http://forums.cpanel.net/f334/mysql-...tml#post818311

    If you don't have bin logs enabled, could you open up a ticket with us to check further? We'll have to try to run the command to see the results as well as check the user's permissions.

    Thanks!
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  6. #6
    Registered Member
    Join Date
    Sep 2009
    Posts
    5

    Default Re: Access denied; you need the SUPER privilege for this operation

    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. #7
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel Access Level

    Root Administrator

    Default Re: Access denied; you need the SUPER privilege for this operation

    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).
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

Similar Threads

  1. Replies: 3
    Last Post: 05-28-2014, 01:52 PM
  2. Replies: 3
    Last Post: 02-05-2011, 11:51 PM
  3. super user ftp access
    By danis in forum General Discussion
    Replies: 2
    Last Post: 10-21-2008, 05:08 AM
  4. Access denied by access control list
    By trout21 in forum General Discussion
    Replies: 4
    Last Post: 10-15-2004, 08:36 AM
bargain