Web Hosting Talk







View Full Version : Access denied only for stored procedure


GeXus
04-21-2007, 07:11 PM
I'm trying to run a stored procedure (mysql 5) in Query Browser

DELIMITER //
CREATE PROCEDURE sp_get_category()
BEGIN
SELECT category_id FROM categories;
END //

When I run this, I get Access Denied for user. I granted all privileges to this user and checked to make sure it's set (it is). I can access the database and do anything, except stored procedures.

Any ideas how I can fix this?

Thanks!