You don't have necessary privilege to create a routine

sibinkumar

Member
Feb 18, 2014
11
0
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
 

cPanelPeter

Senior Technical Analyst
Staff member
Sep 23, 2013
586
25
153
cPanel Access Level
Root Administrator
[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.
 

sreeninair

Well-Known Member
Dec 23, 2013
100
0
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
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Internal case number 93005 was included with cPanel version 11.42.1.1.

Thank you.
 

cenourinha

Well-Known Member
PartnerNOC
Jan 8, 2011
51
2
58
Portugal
cPanel Access Level
DataCenter Provider
Twitter

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
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.
 
Thread starter Similar threads Forum Replies Date
K Databases 2
T Databases 10
U Databases 5
S Databases 2
R Databases 0