MySQL - run SELECT statement on another server without defining the table structure In MySQL I can query information on another server using federated tables, as long as I've defined the same table structure locally.

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?
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.