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!

You don't have necessary privilege to create a routine

Discussion in 'Database Discussion' 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:
    143
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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,585
    Likes Received:
    440
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Multiple threads on same topic merged.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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 Technical Support Community Manager
    Staff Member

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

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    41
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Portugal
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cenourinha, Nov 26, 2014
  11. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,966
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #11 cPanelMichael, Dec 3, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - don't necessary privilege
  1. mokerosan

    Why don't NS records contain IP addresses?

    mokerosan, Nov 20, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    170
    cPanelMichael
    Nov 21, 2018
  2. jazee

    Forward Existing Email Account and Don't Retain

    jazee, Aug 31, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    133
    cPanelMichael
    Aug 31, 2018
  3. LinuxUserSince1991

    'Track Delivery' settings don't stick

    LinuxUserSince1991, Aug 1, 2018, in forum: User Experience
    Replies:
    4
    Views:
    225
    LinuxUserSince1991
    Aug 3, 2018
  4. diracuser

    Exim Custom Filters don't work

    diracuser, May 30, 2018, in forum: E-mail Discussion
    Replies:
    6
    Views:
    276
    diracuser
    May 31, 2018
  5. globcom

    You don't have DMARC record error

    globcom, May 21, 2018, in forum: E-mail Discussion
    Replies:
    3
    Views:
    521
    cPanelLauren
    May 21, 2018

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.
    Accept Learn More...
    Dismiss Notice