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