Could not execute query in MySQL (issue with privileges)

Asked Aug 31 '15 at 07:22

Active Aug 31 '15 at 10:46

Viewed 125 times

I am trying to do this:

grant select on `mysql`.`proc` to `some_user`%`host`;
grant execute on procedure `database_name`.`get_some_data` to `some_user`@`host`;
flush privileges;

When my application calls, it throws the following error:

 org.hibernate.util.JDBCExceptionReporter - execute command denied to user 'some_user'@'142.24.%.%' for routine 'database_name.get_some_data' at
 com.lsa.nameless.dao.AnalyticsDao.callStoredProcedure(AnalyticsDao.java:43)
 at com.lsa.nameless.service.AnalyticsService.findBrandPerformanceData(AnalyticsService.java:1672) 
 at com.lsa.nameless.action.AnalyticsAction.showPage(AnalyticsAction.java:240)

When I do execute show grants for user@host, I do see that I the user actually has privileges to execute the procedures and functions.

I have also tried granting privileges on procedures and functions separately. Still, not working.

edited Aug 31 '15 at 10:46

Neil Stockton

11,383
3
34
29

asked Aug 31 '15 at 07:22

MontyPython

2,906
11
37
58

4

Add your code and the complete stacktrace. – Jens Aug 31 '15 at 07:25
@Jens - added the complete stacktrace. – MontyPython Aug 31 '15 at 07:54
Looks like the user you logged on with have no privileges to execute grant statements – Jens Aug 31 '15 at 07:55
@Jens - updated the summary, last time it worked by just doing a grant select on mysql.proc to the user@host. – MontyPython Aug 31 '15 at 08:07
The stacktrace contains the username `some_user` whilst your SQL uses `user`. – Tobias Aug 31 '15 at 08:08
@still_learning - I had to change the user/host name. Security issues. some_user and user are the same. – MontyPython Aug 31 '15 at 08:11
Check out this: https://stackoverflow.com/questions/6434573 – Marinos An Sep 09 '15 at 11:21

Could not execute query in MySQL (issue with privileges)

0 Answers0