Creating Stored Procedure: Access denied

[solepixel]

I've never created a stored procedure before, ever, and it appears it's the only safe way to pass variables to MySQL in ASP.NET. So i'm using SQLYog which pretty much writes most the Create Procedure statement for me, however, when I execute it, I get: Access Denied - Error Code: 1044

I have full access to this database, and even tried logging in as the root user yet still get the same error. Is there something I must do in MySQL configuration to allow for this? I've looked through the permissions and there's nothing else I can get granted access to, I have it all. Thanks.

 

[r937]

can we see the first few lines of your CREATE PROCEDURE statement please

r937.com | rudy.ca

 

[solepixel]

DELIMITER $$

DROP PROCEDURE IF EXISTS `alatelco`.`getContent`$$

CREATE PROCEDURE `alatelco`.`getContent` ()
BEGIN

Then my select statement or whatever

SELECT * FROM content;

END$$

DELIMITER ;