MySQL Forums
Forum List  »  Federated Storage Engine

Unable to connect to foreign data source
Posted by: Dedy Black
Date: November 17, 2010 10:28PM

local ip : 192.168.5.25
remote ip : 192.168.5.6

I tried to practice from this source http://dev.mysql.com/doc/refman/5.0/en/federated-use.html. I created two tables like the instructions.

on a remote server:
CREATE TABLE test_table (
id INT (20) NOT NULL AUTO_INCREMENT,
name VARCHAR (32) NOT NULL DEFAULT'',
other INT (20) NOT NULL DEFAULT '0 ',
PRIMARY KEY (id),
INDEX name (name),
INDEX other_key (other)
)
ENGINE = MyISAM
DEFAULT charset = latin1;

on the local server:
CREATE TABLE federated_table (
id INT (20) NOT NULL AUTO_INCREMENT,
name VARCHAR (32) NOT NULL DEFAULT'',
other INT (20) NOT NULL DEFAULT '0 ',
PRIMARY KEY (id),
INDEX name (name),
INDEX other_key (other)
)
ENGINE = Federated
DEFAULT charset = latin1
CONNECTION = 'mysql: / / root@192.168.5.6: 9306/federated/test_table';

but after the command is executed an error occurs: Unable to the connect to foreign data source: Can not the connect to MySQL server on '192 .168.5.6 '(10 061)
(2921 sec)

what is wrong and what's the solution?
thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to connect to foreign data source
13611
November 17, 2010 10:28PM


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.