Skip to main content

You don't have necessary privilege to create a routine

sibinkumar
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

Comments

10 comments

Date Votes
  • cPanelPeter cPanel Staff
    [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.
    0
  • sreeninair
    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
    0
  • Infopro
    Multiple threads on same topic merged.
    0
  • sibinkumar
    Re: [Case # 93005] - Re: You don't have necessary privilege to create a routine Thanks for the update.
    0
  • sreeninair
    Hello, When will the version available? Thanks Sreeni
    0
  • cPanelMichael
    Internal case number 93005 was included with cPanel version 11.42.1.1. Thank you.
    0
  • Mario Franco
    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?
    0
  • peterparker
    erorr whith MySQL, does not Cpanel! i think so
    0
  • cenourinha
    I'm able to reproduce this issue. Running MySQL 5.5.40-cll with phpMyAdmin 4.0.10.5. This seems to be fixed in the new phpMyAdmin versions: [url=http://sourceforge.net/p/phpmyadmin/bugs/4489/?page=3]phpMyAdmin / Bugs / #4489 (ok 4.2.6) Incorrect detection of privileges for routine creation Can you please update the phpMyAdmin version included with cPanel?
    0
  • cPanelMichael
    [quote="Mario Franco, post: 1778462">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?
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post