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