MySQL Forums
Forum List  »  Security

Re: create function / procedure local vs. remote
Posted by: Jay Alverson
Date: February 23, 2009 09:13AM

Matthew Wrote:
> Thanks for the reply.
> That certainly makes sense. I assume there is a
> setting I need to make on the DB instance on
> machine A (in the above example) to allow for such
> things. Question becomes, how does one do this (as
> I cannot see it when using MySQL Administrator)?
> Matthew

You mean how do setup the account to be able to work with Stored Procedures ?

Download the MySQL Manual for your version at:

Checkout Chapters
5.5. MySQL User Account Management

Basically MySQL has two accounts for every user (or possibly more), username@localhost and username@% and you have to setup each one and duplicate their privs to be able to work the same.

I'm testing v6.0 of MySQL and it required me to logon to the server as root@localhost and grant special privs to the root@% to let it execute Events. So make sure you test as much as possible.

Make sure you use FLUSH PRIVILEGES.


Thanks, Jay

Options: ReplyQuote

Written By
Re: create function / procedure local vs. remote
February 23, 2009 09:13AM

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.