MySql (Update-) SP only works in terminal ?

Question

I have a stored procedure that works in the mysql> terminal, but when I try to run it through my application it doesn't work. I don't get any error messages or anything. If I try to execute the sp through MySql Query Browser the response is simply :
"Query canceled."

This particular SP is just a simple update command, but I have other SP that are SELECT commands and they work.

Ive tried changing the DEFINER to '%' and '' but neither of that worked.

I'm thinking this has to be some kind of a permission problem or a my.cnf problem but I have no idea how to fix this nor do I seem to be able to find a solution on the internet machine :)

EDIT: I just tried to execute it from phpmyadmin and that worked. I tried both as root and myUser. What is going on ?

Answer 1

If you can run select based stored procedures, and not the update one, the user you are connecting with query browser has insufficient privileges on some tables or columns updated by the stored procedure. You can check that with the user manager.

Obs: your_user@localhost seems to be ok as you can run with phpmyadmin but with query browser, the user is your_user@%.