Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Problem in Executing store procedure?
- Amit Prakash Pawar
May 17, 2010, 5:27 am
rate this thread
I am trying to run a stored procedure from PHP file,i am getting
following error :
execute command denied to user 'user_name'@'localhost' for routine
'dbname.fetch_gist' on 70
When i directly call stored procedure from phpmyadmin it works fine ,
but when i call the same from php file the above shown error occurs.
My php CODE is :
AND MY STORED PROCEDURE IS:
CREATE PROCEDURE fetch_gist()
SELECT * FROM pm_user;
plz kindly give me solution for this.
Re: Problem in Executing store procedure?
My guess is the execute privilege isn't set for user_name. Use
phpmyadmin to set that privilege for user_name in that database and this
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]