MySQL Forums
Forum List  »  Stored Procedures

Re: Call Procedure in MySQL from another MySQL
Posted by: Peter Brawley
Date: August 04, 2019 09:18PM

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.

Options: ReplyQuote

Written By
Re: Call Procedure in MySQL from another MySQL
August 04, 2019 09:18PM

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.