Re: create function / procedure local vs. remote
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