MySQL Forums
Forum List  »  MySQL Workbench

Re: Accessing remote data
Posted by: Martin Weaver
Date: May 23, 2017 01:46PM

Ok let me ask a different question because this does not exactly answer my initial question. I want to retrieve the data from a table on server1 by using a select statement on server2.

Now i have been able to mostly get the function FEDERATED to work.

Where i am having problems at is the host name. Here is my connect string, instead of using the IP address i want to be able to use the computer name but it does not seem to want to resolve the computer name.

ENGINE=FEDERATED CONNECTION = 'mysql://root:visons@'

I want to use the computer name instead of the IP so can i do so and if so how?

Options: ReplyQuote

Written By
May 23, 2017 08:13AM
May 23, 2017 10:33AM
Re: Accessing remote data
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.