How can I enable the federated engine in mysql after installation?

Question

I have mysql 5.1.44:

 mysql> show engines; +------------+---------+ | Engine     | Support |  +------------+---------+ | ndbcluster | NO      |  | MRG_MYISAM | YES     |  | BLACKHOLE  | YES     |  | CSV        | YES     |  | MEMORY     | YES     |  | FEDERATED  | NO      |  | ARCHIVE    | YES     |  | InnoDB     | YES     |  | MyISAM     | DEFAULT | 

I need to enable federated engine in mysql. How can I do it?

Answer 1

Edit /etc/my.cnf and in the [mysqld] section, add the line:

federated 

It's equivalent to specifying --federated on the command line