MySQL Forums
Forum List  »  MySQL Workbench

Accessing remote data
Posted by: Martin Weaver
Date: May 23, 2017 08:13AM

Ok I am going to do my best as describing this. I have 1 server located at and i have 1 PC located at both of them have mysql on them. On the PC i have a tabled called CSM2, what i want to be able to do is retrieve the information for the table CSM2 on the server pc.

From what i have read MySql does not have the same ability at Microsoft SQL where in the command line you can say: Select * from SERVER.database.dbo.table

Or can it be done the above way?

If not is federated the only and best way to do this?

And how do you enable it in a windows environment? not in command line

Options: ReplyQuote

Written By
Accessing remote data
May 23, 2017 08:13AM
May 23, 2017 10:33AM
May 23, 2017 01:46PM
May 23, 2017 02:28PM
May 24, 2017 04:45AM

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.