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!
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!
