How is a "linked server" connection different than any other connection defined by a MySQL client?
In MS SQL Server, however, I can run any SQL statement against a
linked server. Is it possible to do the same thing in MySQL?
Maybe I'm missing something but yes, just setup a connection.
mysql -u <user> -p <password> -D <database> -H 127.0.0.1
db = MySQLdb.connect(host="localhost", user="<user>", passwd="<password>", db="<database>")
You could go so far as setting up a reverse tunnel with SSH.
mysql -u <user> -p <password> -D <database> -H 127.0.0.1 -P 33061
Other than that,
FEDERATED tables are the closet thing.
I must be missing something.