Skip navigation links

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


Advanced Search

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 5145 Matthew 01/28/2007 01:54PM
Re: create function / procedure local vs. remote 2913 Bob Field 01/28/2007 02:21PM
Re: create function / procedure local vs. remote 2835 Matthew 01/28/2007 05:49PM
Re: create function / procedure local vs. remote 2725 Jay Alverson 02/23/2009 09:13AM
Re: create function / procedure local vs. remote 2523 manoj sharma 02/23/2009 06:02AM


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.