MySQL - run SELECT statement on another server without defining the table structure
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 &lt;user&gt; -p &lt;password&gt; -D &lt;database&gt; -H 127.0.0.1

import MySQLdb
db = MySQLdb.connect(host="localhost", user="&lt;user&gt;", passwd="&lt;password&gt;", db="&lt;database&gt;")


You could go so far as setting up a reverse tunnel with SSH.

mysql -u &lt;user&gt; -p &lt;password&gt; -D &lt;database&gt; -H 127.0.0.1 -P 33061


Other than that, FEDERATED tables are the closet thing.

I must be missing something.