Home > Database > Mysql Tutorial > body text

How to Enable the Federated Engine in MySQL?

Patricia Arquette
Release: 2024-11-01 11:41:30
Original
436 people have browsed it

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;
Copy after login

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
Copy after login

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
Copy after login

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!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!