安装后如何在mysql中启用联合引擎? [英] how can i enable federated engine in mysql after installation?

问题描述

我有mysql 5.1.44

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 |

现在，我需要在mysql中启用联合引擎，该怎么办?

now, i need to enable federated engine in mysql, how can i do so?

推荐答案

编辑/etc/my.cnf并在[mysqld]部分中，添加以下行:

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

federated

等效于在命令行上指定--federated

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

这篇关于安装后如何在mysql中启用联合引擎?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！