How to Enable the Federated Engine in MySQL?

Enabling the Federated Engine in MySQL after Installation

To enable the federated engine in MySQL 5.1.44, follow these steps:

1. Check Engine Support

Before enabling the federated engine, verify that it is not already supported by executing the following command:

show engines;

If the output does not list FEDERATED as supported, proceed to the next step.

2. Edit MySQL Configuration

Open the MySQL configuration file (/etc/my.cnf) and locate the [mysqld] section. Add the following line under this section:

federated

3. Optionally Specify on Command Line

Instead of modifying the configuration file, you can also specify the --federated option when starting the MySQL server via the command line:

$ mysqld --federated

4. Restart MySQL Server

Restart the MySQL server to activate the changes made in the configuration.

By following these steps, you can successfully enable the federated engine in MySQL, allowing you to query and retrieve data from remote MySQL servers.

The above is the detailed content of How to Enable the Federated Engine in MySQL?. For more information, please follow other related articles on the PHP Chinese website!