Execute command denied to user ''@'localhost' for routine error

Question

I have 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?

biniam · Accepted Answer · 2016-09-23 11:01:50Z

53

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, 2016 at 11:01

biniam

8,2479 gold badges51 silver badges58 bronze badges

answered Sep 10, 2011 at 8:03

nunu

2,8719 gold badges37 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sydwell · Accepted Answer · 2014-03-11 21:02:32Z

19

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, 2014 at 21:02

Sydwell

5,0231 gold badge35 silver badges36 bronze badges

Comments

Max Izrin · Accepted Answer · 2016-11-23 07:33:44Z

9

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, 2016 at 7:33

Max Izrin

9551 gold badge11 silver badges18 bronze badges

1 Comment

Krunal Over a year ago

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)

yeatsie · Accepted Answer · 2023-10-09 11:36:48Z

4

I got the same error when trying to use the MIN function in my query.

Error Code: 1370. execute command denied to user 'a.user'@'%' for routine 'mysqlserver.MIN'

MySQL didn't like seeing a space before MIN and the opening (.

After reading the above and trying MIN(..) instead of MIN (..) my query worked.

Go figure.

answered Oct 9, 2023 at 11:36

yeatsie

1379 bronze badges

1 Comment

Zim84 Sep 25 at 14:19

+1 That was my issue as well. When executing the same statement with "COUNT" via PhpMyAdmin's SQL "console", you get no error. But when executed as my own PHP script, I get that strange error. Removing the white space solves the issue.

kat · Accepted Answer · 2022-01-06 14:05:13Z

3

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 6, 2022 at 14:05

kat

491 bronze badge

2 Comments

Vani Gupta Over a year ago

This is pretty weird as I already had the privileges. But this worked for me! None of the answers did, thanks

csrowell Over a year ago

Yes, this was exactly my issue. This is an answer to the question.

IonV · Accepted Answer · 2020-04-11 08:47:58Z

-1

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, 2020 at 8:47

IonV

471 silver badge6 bronze badges

2 Comments

Marcinek Over a year ago

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.

Scratte Over a year ago

@Marcinek This seems to me like another situation where the mentioned error may confusingly occur, and how to fix it by fixing the SQL.

spathode · Accepted Answer · 2024-07-12 18:26:23Z

-1

Very very late to the party. I also committed a syntax mistake and got the same error. I used a space between my MAX function - MAX (ABC). Got it working after removing the space MAX(ABC).

answered Jul 12, 2024 at 18:26

spathode

11 bronze badge

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Execute command denied to user ''@'localhost' for routine error

7 Answers 7

Comments

Comments

1 Comment

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

1 Comment

1 Comment

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related