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.

You don't have necessary privilege to create a routine

Discussion in 'Database Discussions' started by sibinkumar, Apr 5, 2014.

  1. sibinkumar

    sibinkumar Member

    Joined:
    Feb 18, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Not able to create routine.

    Getting "You don't have necessary privilege to create a routine"

    Mysql version : 5.5

    phpmysql 4.1

    cpanel version: 11.42
     
    #1 sibinkumar, Apr 5, 2014
  2. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    573
    Likes Received:
    19
    Trophy Points:
    93
    cPanel Access Level:
    Root Administrator
    Twitter:
    [Case # 93005] - Re: You don't have necessary privilege to create a routine

    Hello,

    There is/was an internal case open on this issue. Case # 93005, has been resolved in cPanel version 11.42.1.0
    Once this version is available in your update TIER, it should be fixed when you are upgraded to that version/release.
     
    #2 cPanelPeter, Apr 6, 2014
  3. sreeninair

    sreeninair Well-Known Member

    Joined:
    Dec 23, 2013
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    You do not have the necessary privileges to create a routine: Mysql

    Hello Guys,

    I am facing some issues with my mysql server. I cannot add routine through phpmyadmin. When I select a database and click on 'Routines' I am getting error as follows.

    ====

    You do not have the necessary privileges to create a routine"

    ====

    PRIVILEGES FOR THE USER:
    ---------------------------------------------

    mysql> SHOW GRANTS FOR 'test_test'@'localhost';
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id: 521
    Current database: *** NONE ***

    +---------------------------------------------------------------------------------------------------------------------+
    | Grants for test_test@localhost |
    +---------------------------------------------------------------------------------------------------------------------+
    | GRANT USAGE ON *.* TO 'test_test'@'localhost' IDENTIFIED BY PASSWORD '*PASSWORS' |
    | GRANT ALL PRIVILEGES ON `test\_test`.* TO 'test_test'@'localhost' |
    +---------------------------------------------------------------------------------------------------------------------+
    2 rows in set (0.00 sec)

    ===========

    Server cPanel version is
    root@server [~]# /usr/local/cpanel/cpanel -V
    11.42.0 (build 23)
    root@server [~]#

    ============

    Please help me on this.

    Thanks
    Sreeni
     
    #3 sreeninair, Apr 6, 2014
    Last edited: Apr 6, 2014
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,553
    Likes Received:
    292
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Multiple threads on same topic merged.
     
    #4 Infopro, Apr 6, 2014
  5. sibinkumar

    sibinkumar Member

    Joined:
    Feb 18, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Re: [Case # 93005] - Re: You don't have necessary privilege to create a routine

    Thanks for the update.
     
    #5 sibinkumar, Apr 7, 2014
  6. sreeninair

    sreeninair Well-Known Member

    Joined:
    Dec 23, 2013
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello,
    When will the version available?

    Thanks
    Sreeni
     
    #6 sreeninair, Apr 8, 2014
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,385
    Likes Received:
    1,210
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Internal case number 93005 was included with cPanel version 11.42.1.1.

    Thank you.
     
    #7 cPanelMichael, Apr 10, 2014
  8. Mario Franco

    Mario Franco Registered

    Joined:
    Oct 24, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mexico City, Mexico, Mexico
    cPanel Access Level:
    Root Administrator
    The error is appearing again in the servers I'm currently managing with MySQL 5.5.40 and cPanel/WHM 11.46.0 (build 17). Is it just me or it's an error with cPanel?
     
    #8 Mario Franco, Nov 25, 2014
  9. peterparker

    peterparker Registered

    Joined:
    Nov 26, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    erorr whith MySQL, does not Cpanel! i think so
     
    #9 peterparker, Nov 26, 2014
  10. cenourinha

    cenourinha Active Member
    PartnerNOC

    Joined:
    Jan 8, 2011
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Portugal
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    #10 cenourinha, Nov 26, 2014
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,385
    Likes Received:
    1,210
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Internal case number 139837 is open to address the re-occurrence of this issue. Please monitor our change log for the inclusion of this case number:

    11.46 Change Log

    Thank you.
     
    #11 cPanelMichael, Dec 3, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - don't necessary privilege
  1. webservers

    Don't Want To Use Paper Lantern

    webservers, Jun 10, 2017, in forum: User Experience
    Replies:
    1
    Views:
    121
    Infopro
    Jun 10, 2017
  2. manokiss

    Domains Don't Resolve Without Restarting PowerDNS

    manokiss, May 25, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    139
    cPanelMichael
    May 26, 2017
  3. Sattar

    Technically explain why some emails don't arrive destination

    Sattar, May 17, 2017, in forum: E-mail Discussions
    Replies:
    1
    Views:
    125
    Infopro
    May 17, 2017
  4. Elnur Babayev

    NS records updates don't propagate

    Elnur Babayev, May 10, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    1
    Views:
    90
    cPanelMichael
    May 10, 2017
  5. RCady

    Site is Redirecting to www.* when rules don't exist

    RCady, May 3, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    143
    kdean
    May 11, 2017

Share This Page