Re: Call Procedure in MySQL from another MySQL

[Peter Brawley]

In whatever client you're using, you'd need to connect to the MySQL instance on the other server, logging in as a user with privs for that sproc and what it does.

If the client is the MySQL client program, you'd need to run another instance of the client program. The 2nd instance would know nothing of the first instance unless you passed it commandline arguments carrying that info.

If the client were an app written in a language for which there's a MySQL API (PHP, Python, C#, Java &c), you could initialise and make a 2nd connection, to which you could pass values that the app had assembled from the first connection. Note however that each connection's routines would be running against just the server to which its connected.