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!
  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:
    575
    Likes Received:
    20
    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:
    16,067
    Likes Received:
    348
    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:
    42,763
    Likes Received:
    1,710
    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:
    42,763
    Likes Received:
    1,710
    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. sicay

    CardDav contacts don't have email addresses

    sicay, Apr 22, 2018 at 11:58 PM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    26
    cPanelLauren
    Apr 23, 2018 at 10:40 AM
  2. Thunderchild

    apparently I don't have mysqli

    Thunderchild, Feb 3, 2018, in forum: Database Discussions
    Replies:
    10
    Views:
    244
    Thunderchild
    Feb 13, 2018
  3. Oualid

    Your local nameservers don't return IP addresses

    Oualid, Dec 3, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    6
    Views:
    375
    cPanelMichael
    Dec 11, 2017
  4. Outlier

    If I don't use SSH to connect, would it be ok if I don't update the SSH version?

    Outlier, Sep 1, 2017, in forum: Security
    Replies:
    2
    Views:
    243
    cPanelMichael
    Sep 1, 2017
  5. webservers

    Don't Want To Use Paper Lantern

    webservers, Jun 10, 2017, in forum: User Experience
    Replies:
    1
    Views:
    380
    Infopro
    Jun 10, 2017

Share This Page