MySQL Forums :: Security :: create function / procedure local vs. remote

Hello,

I have my database on machine A.

Using MySQL Query Browser...

On machine A, I can create a function / procedure locally when logged on as root.

On machine B, I can log onto the DB on machine A (again as root), but I cannot create procedures or functions on machine A.

Here's some typical syntax (where xxx is the schema and yyyyy is the function)...

DELIMITER $$

DROP FUNCTION IF EXISTS `xxx`.`yyyyy` $$
CREATE FUNCTION `xxx`.`yyyyy`(pName VARCHAR(1024)) RETURNS varchar(1024)
BEGIN

return '';

END $$

DELIMITER ;

Anyone know what's going on?

Thanks,

Matthew