How to enable FEDERATED storage engine which is in disabled mode by default

[susmitha m]

Hi,
I am using MySQL 5.4 DB. I googled a lot and searched in forums also for enabling FEDERATED storage engine which is in disabled mode by default.

When i am executing query regarding Federated engine, it is showing error "Unknown storage engine".

query i executed is as:
CREATE TABLE `federated`.`federated_table1` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL DEFAULT '',
`other` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `other_key` (`other`)
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://user1:user1@localhost:3306/federated/test_table';