Federated Table issue
Dear All,
I am using MySQL 5.1.46 and I have created following server and federated table,
CREATE SERVER s1
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'root', PASSWORD 'root123',HOST '192.178.0.187', PORT 3306, DATABASE 'test');
drop table if exists test_table;
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=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='s1/test_table';
Now when I am going to insert data into test_table I got error "[Err] 1429 - Unable to connect to foreign data source: Can't connect to MySQL server on '192.178.0.187' (113)". The table is created on host 192.168.0.187 and federated table is created on Host: 192.168.0.122 and I can easily connect to mysql running .187 server from .122 server.
Please let me know what I am doing wrong which causing this error? Is there anything wrong with create server command.
Any help would be greatly appreciated.
Regards,
Shirazi
|