MySQL Forums
Forum List  »  Security

create function / procedure local vs. remote
Posted by: Matthew
Date: January 28, 2007 01:54PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
create function / procedure local vs. remote
6528
January 28, 2007 01:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.