I've been at it for a while, but I just can't seem to get the syntax right on granting execute permission on stored procedures to my MySQL user.
I've tried to track down examples online, and tried to figure it out from the MySQL website docs, but I still can't seem to get it to work.
I'm trying to do something like this inside the MySQL Query Browser:
grant execute on *.* to 'my_username'
If I try a wildcard, I get the error 1045 - Access denied for (insert user here)
If I try it on a specific stored procedure, I get the error 1144 - Illegal GRANT/REVOKE command.
I'm an MSSQL guy, and this is my first go at using MySQL, so bear with me gang
Thanks for any help you can provide.