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

 

[cPanelPeter]

[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]

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 [email protected] |
+---------------------------------------------------------------------------------------------------------------------+
| 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
[email protected] [~]# /usr/local/cpanel/cpanel -V
11.42.0 (build 23)
[email protected] [~]#

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

Please help me on this.

Thanks
Sreeni

 

[Infopro]

Multiple threads on same topic merged.

 

[sibinkumar]

Re: [Case # 93005] - Re: You don't have necessary privilege to create a routine

Thanks for the update.

 

[sreeninair]

Hello,
When will the version available?

Thanks
Sreeni

 

[cPanelMichael]

Internal case number 93005 was included with cPanel version 11.42.1.1.

Thank you.

 

[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?

 

[peterparker]

erorr whith MySQL, does not Cpanel! i think so

 

[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: phpMyAdmin / Bugs / #4489 (ok 4.2.6) Incorrect detection of privileges for routine creation

Can you please update the phpMyAdmin version included with cPanel?

 

[cPanelMichael]

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.