Mysql: execute command denied to user ''@'localhost' for routine error

Question

i got some problem during open my old website. My dataTable show:

DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

After that, I tried to debug my script and found error in mysql:

Error occuered during query execution: 
(<small>SELECT SQL_CALC_FOUND_ROWS ID,name,remark,avrusepmonth 
        , CONCAT('&lt;input type=''checkbox''id=''cb' , ID ,''' name=''check[]''                
        value=''',ID,''' &gt;','&lt;label class=''lbcb'' for=''cb', 
        ID,'''&gt;&lt;=update=&lt;/label&gt;') as checkb 
        ,monthavrage(ID,12) as latestavr , moq, leadtime 
        FROM test_media  WHERE nowuse=1 and monthavrage(ID,12)  &gt; 0  ORDER BY  name
        desc, ID
        LIMIT 0, 10</small>):
 execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'

Then I tried to googling for execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage' and some sites said that I must do some GRANT:

GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'localhost'

but I got:

#1370 - execute command denied to user 'jeinqa'@'localhost' for routine 'TestMediaControl.monthavrage'

could you tell me how should I do for solving this?

score 51 · Accepted Answer · edited Sep 23 '16 at 11:01

51

It works..... I try to grant this priviledge in root.

log in as root
GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'localhost'
flush privileges;

edited Sep 23 '16 at 11:01

biniam

8,099
9
49
58

answered Sep 10 '11 at 08:03

nunu

2,703
9
33
55

score 18 · Answer 2 · answered Mar 11 '14 at 21:02

18

Very late to the party also try a combination of.

GRANT EXECUTE ON PROCEDURE TestMediaControl.monthavrage TO 'jeinqa'@'%';

AND

flush privileges;

Also try replacing PROCEDURE with FUNCTION.

answered Mar 11 '14 at 21:02

Sydwell

4,954
1
33
36

score 8 · Answer 3 · answered Nov 23 '16 at 07:33

8

I have encountered this in phpMyAdmin, a few hours ago, when executing a stored procedure with what I thought would be detected as a syntax error.

I was missing a comma between a field name, and a calculated field, and this gave me the same error message.

answered Nov 23 '16 at 07:33

Max Izrin

938
1
11
17

2

Ha ha, this is not a technical solution for problem but a solution to syntax error and I had a same problem that I could solved using this one... Great....! (I wish I could give 2 upvotes to this answer) – Krunal Nov 05 '18 at 05:00

score 1 · Answer 4 · answered Jan 06 '22 at 14:05

1

I had the problem too - my error was quoting was with routine count - access denied.

The problem was I had "count (case when...)" and there cannot be a space between count and (. removing spaces fixed the error.

answered Jan 06 '22 at 14:05

kat

21
1

This is pretty weird as I already had the privileges. But this worked for me! None of the answers did, thanks – Vani Gupta Apr 12 '22 at 07:28
Yes, this was exactly my issue. This is an answer to the question. – csrowell May 01 '23 at 13:56

score -2 · Answer 5 · answered Apr 11 '20 at 08:47

-2

I encountered this yesterday, I expected a syntax error but this message was shown.

My mistake: I wrote "SELECT m.id, m.MAX(id_number) as id_number..." instead of "SELECT m.id, MAX(m.id_number) as id_number...".... the error is with the MAX. The error message wasn't too helpful.

answered Apr 11 '20 at 08:47

IonV

37
6

This seems to be a follow up question. Maybe it would be better to post this as a comment, rather than a question. If you have a question please start a new one. – Marcinek Apr 11 '20 at 08:55
@Marcinek This seems to me like another situation where the mentioned error may confusingly occur, and how to fix it by fixing the SQL. – Scratte Apr 11 '20 at 09:20

Mysql: execute command denied to user ''@'localhost' for routine error

5 Answers5

Linked