access denied to a function!

[lagavulin]

I try to accessing a stored function in mysql server, but i receive error this error query error: execute command denied to user xxxxx for routine myuser@starka.x10hosting.com

To solve this problem I've tried to grant user access the stored function with GRANT SELECT ON database.function TO myuser@starka.x10hosting.com, but I receive that error #1142 - GRANT command denied to userxxxxxxxxxxxx for table xxxxxxxxx.

where I'm wrong?

 

[garrettroyce]

You can use PHPMyAdmin from your CPanel to get a graphical idea of what is happening. When you log in, you have all possible permissions on your own databases, so you can grant and give grant option to whomever needs it.

Also, trying to run the query from within PHPMyAdmin may be slightly more helpful because it tends to give you more information.

 

[descalzo]

If you get it to work, please post your solution.
I tried to get mySQL to accept a "SELECT * INTO OUTFILE" request, but it keeps comming back access denied. And I had set up the user with all the permissions at the time.

 

[lagavulin]

I've tried the same query directly into phpMyAdmin and the result is what I hope. But from php apps it doesnt work.

where in phpmyadmin can I set permission on my stored function?

 

[garrettroyce]

Sorry, I'm thinking of the full version of PHPMyAdmin, not the limited X10 version. You need to use the MySQL Databases tool for permissions.