Connect to another host from inside mysql stored procedure
No.  One connection can talk to only one MySQL server.
Any Stored Routine lives in a single MySQL server, so another connection is not allowed for.