Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   Federated on MySQL error (http://www.go4expert.com/forums/federated-mysql-error-t23922/)

karabibe 19Nov2010 13:07

Federated on MySQL error
 
i use xampp v1.6.8

setup:
local ip : 192.168.5.25
remote ip : 192.168.5.6

I tried to practice from this source:
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


All times are GMT +5.5. The time now is 17:50.