Skip navigation links

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


Advanced Search

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:
http://dev.mysql.com/doc/#refman

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


Subject Views Written By Posted
create function / procedure local vs. remote 5062 Matthew 01/28/2007 01:54PM
Re: create function / procedure local vs. remote 2867 Bob Field 01/28/2007 02:21PM
Re: create function / procedure local vs. remote 2784 Matthew 01/28/2007 05:49PM
Re: create function / procedure local vs. remote 2653 Jay Alverson 02/23/2009 09:13AM
Re: create function / procedure local vs. remote 2484 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.