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@192.168.0.171:3306/ezmysqltest/csm2'
DEFAULT CHARSET=utf8;

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

Options: ReplyQuote


Subject
Views
Written By
Posted
121
May 23, 2017 08:13AM
35
May 23, 2017 10:33AM
Re: Accessing remote data
41
May 23, 2017 01:46PM
30
May 23, 2017 02:28PM
37
May 24, 2017 04:45AM


Sorry, only registered users may post in this forum.

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.