How do I enable the Federated Engine in MySQL after installation?

Enabling the Federated Engine in MySQL after Installation

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

Identifying the Current Engine Status

Using the show engines statement, you can check the availability of the federated engine in your MySQL instance. If the "Support" column for the FEDERATED engine is set to NO, you need to enable it.

Editing the Configuration File

Open the MySQL configuration file (my.cnf) located in the /etc directory.

Adding the Federated Engine Configuration

In the [mysqld] section of the configuration file, add the following line:

federated

This line enables the federated engine in the MySQL server.

Saving the Configuration File

Save the changes made to the configuration file.

Restarting MySQL

Restart MySQL to apply the configuration changes and enable the federated engine. You can use the following command to restart MySQL:

<code class="bash">service mysql restart</code>

After restarting MySQL, the FEDERATED engine should appear as YES in the Support column when you run the show engines statement.

Additional Notes

Enabling the federated engine allows you to access data from other MySQL instances through federated queries. It is important to note that the FEDERATED engine is deprecated in recent versions of MySQL and may not be available in newer versions.

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